Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
DateTime comparison
Message
From
03/04/2009 10:05:25
Fabio Lunardon
Lunacom
Marostica, Italy
 
 
To
03/04/2009 05:24:38
John Jones
Kuala Lumpur, Malaysia
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Title:
Re: DateTime comparison
Environment versions
SQL Server:
SQL Server 2005
Application:
Web
Miscellaneous
Thread ID:
01392907
Message ID:
01392992
Views:
46
>Hi,
>Thank you. May I know how to compare date only portion in SQL?
>I know we can use CONVERT() but would it be optimized since index cant contain function (could it?). ?
>
>Thank you
... DATEDIFF(day,datetime1,datetime2)=0
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform