Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to compare two dates (excluding time) ?
Message
From
13/02/2002 12:55:34
 
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
Other
Title:
How to compare two dates (excluding time) ?
Miscellaneous
Thread ID:
00619595
Message ID:
00619595
Views:
55
In my database, I use a smalldatetime field. But there is no time part
(all dates with time equal to 0). When I want to include the date in the
where clause of any transaction (like Select or Update command), if the
date to compare with contains time value, the match not exists. How can I
compare two dates only (no time) ?
Marc Levesque
La Prairie, Quebec (CANADA)
marc.levesque@videotron.ca
Next
Reply
Map
View

Click here to load this message in the networking platform