Friday, February 17, 2012

datediff

Hi everyone!
What's the difference between day and dayofyear in the datediff function?
Thanks.
Jaime LucciDay = day of month; Day of Year = number of days since beginning of year (
Jan 1 = 1, Feb 1 = 32, etc.)
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
.
"Jaime Lucci" <jaimelucci@.hotmail.com> wrote in message
news:ePU0mPB9FHA.2152@.TK2MSFTNGP10.phx.gbl...
Hi everyone!
What's the difference between day and dayofyear in the datediff function?
Thanks.
Jaime Lucci

No comments:

Post a Comment