Just Learned - GETDATE() and GETUTCDATE() produce the same output on SQL Azure Database

Getting Started with Adobe After Effects - Part 6: Motion Blur


	Just Learned

A collection of quick technology learning tips from what people around you learn every day


	Submit a tip


	Subscribe..

Home · Most Liked · Most Learned · Most Discussed · Silver Rated · Sections

GETDATE() and GETUTCDATE() produce the same output on SQL Azure Database

Jun 14 2012 12:00AM by Dattatrey Sindol (Datta)

SYSDATETIME(), SYSDATETIMEOFFSET(), SYSUTCDATETIME(), CURRENT_TIMESTAMP, GETDATE(), and GETUTCDATE() functions yield the same result on SQL Azure irrespective of the primary data center. And all of them return the UTC date/time.

Note: Here we are talking about the date at hour/minute granularity and not second/millisecond level of granularity.

3 Comments

While strange for someone like me who has worked on the on-premise SQL server editions all my life, it absolutely makes sense.

commented on Jun 14 2012 1:50PM

Nakul Vachhrajani

4 · 33% · 10564

Yes Nakul you are right. Actually I was going through some SQL Scripts which were written for SQL Azure as part of one of my new assignments and I found that in few places they used GETDATE() (Script written by one guy) and other places GETUTCDATE() (Script written by another guy). This made me think, how does GETDATE() behave on SQL Azure, as you do not know where exactly your server is physically located and when I ran GETDATE() and GETUTCDATE() queries, to my surprise I got the same results. Just searched on the web to make sure my understanding is correct, and hence this post :-)

commented on Jun 15 2012 12:18AM

Dattatrey Sindol (Datta)

43 · 4% · 1333

That's nice of you to share your findings, Dattatrey! Thank-you.

commented on Jun 16 2012 10:33AM

Nakul Vachhrajani

4 · 33% · 10564

Your Comment

Sign Up or Login to post a comment.

"GETDATE() and GETUTCDATE() produce the same output on SQL Azure Database" rated 5 out of 5 by 7 readers