Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Help with Where Clause on Query
Message
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Syntaxe SQL
Divers
Thread ID:
00789447
Message ID:
00789454
Vues:
33
This message has been marked as the solution to the initial question of the thread.
Try
BeginTime >= CAST(CONVERT(char(8), ChargeEnableDate, 112) AS datetime)
>I'm not very good with the DateTime functions, so I'm asking for help. In the query below, I want to limit the rows return to only rows where the date portion of the BeginTime is equal to or greater than the Date portion of the ChargeEnableDate. Can someone help me with the formatting?
>
>Thanks
<snip>
--sb--
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform