Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to use datetime difference in SQL Select?
Message
 
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Environment versions
SQL Server:
SQL Server 2005
Miscellaneous
Thread ID:
01390159
Message ID:
01390384
Views:
43
This message has been marked as a message which has helped to the initial question of the thread.
>I am trying to understand the DATEDIFF() function better. Do I understand correctly that the 1st parameter "dd" really has no literal meaning? That is, you can name this parameter anything and it won't change the result?

The first parameter says, that we need to get difference in days.

http://msdn.microsoft.com/en-us/library/ms189794.aspx

http://doc.ddart.net/mssql/sql70/da-db_6.htm
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform