Showing posts with label everyonewhat. Show all posts
Showing posts with label everyonewhat. Show all posts

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