Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Easy One
Message
De
06/01/2004 10:43:21
Jim Rieck
Quicken Loans/Rock Financial/Title Sourc
Livonia, Michigan, États-Unis
 
 
À
Tous
Information générale
Forum:
ASP.NET
Catégorie:
Bases de données
Titre:
Easy One
Divers
Thread ID:
00864178
Message ID:
00864178
Vues:
69
Below is a SQL statement I am running. The query returns 0 records, but it should return 1 record. The problem is with the end_time portion of the where clause, though I don't know how to fix it.

Please help
SELECT dc_id, taskdtl_id, userid, start_time, end_time, total_time, 
   billable, opcode_id
FROM data_collection 
WHERE taskdtl_id = 240
and userid = 1
and end_time = 01/05/04 
Thanks

Jim
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform