How to use datetime difference in SQL Select? - Level Extreme

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

How to use datetime difference in SQL Select?

Message

From

22/03/2009 12:17:40

Naomi Nosonovsky
Wisconsin, United States

To

22/03/2009 11:44:45

Sergey Berezniker
New York, United States

General information

Forum:

Microsoft SQL Server

Category:

SQL syntax

Title:

Re: How to use datetime difference in SQL Select?

Environment versions

SQL Server:

SQL Server 2005

Miscellaneous

Thread ID:

01390159

Message ID:

01390404

Views:

54

>But not for DATESUBSTRACT(). :)
>
>>BTW the same abbreviations are valid for DATEADD() also :-)

Sergey,

I guess you invented the new function :)

http://www.editdate.com/

If it's not broken, fix it until it is.

My Blog

Click here to load this message in the networking platform