Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Help with Where Clause on Query
Message
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Miscellaneous
Thread ID:
00789447
Message ID:
00789454
Views:
32
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--
Previous
Reply
Map
View

Click here to load this message in the networking platform