How to get last hour records using GMT time....

• thundersplash845

  SSC Eights!

  Points: 957

  More actions

  November 28, 2011 at 3:58 pm

  #146148

  Hi All,

  I want to display records for past hour using GMT time... I'm currently using the below syntax to get previous hour records.But I dont want to define any value..Can anyone help me on this??

  DateAdd (hh, -12, getdate())

  -12 hours for Summer and -11 hours for Winter

• Ron McCullough

  SSC Guru

  Points: 63877

  More actions

  November 28, 2011 at 5:08 pm

  #1413708

  Look at the function GETUTCDATE() for example

  SELECT GETUTCDATE(),GETDATE()

  Results

  --GETUTCDATE GETDATE

  2011-11-29 00:03:56.0002011-11-28 19:03:56.003

  Here is a good discussion for you to read:

  http://sqlserverperformance.wordpress.com/2007/04/25/one-way-to-convert-from-utc-time-to-local-time/

  Is this what you are looking for ? If not post back and some else may assist you.

  If everything seems to be going well, you have obviously overlooked something.

  Ron
  
  Please help us, help you -before posting a question please read[/url]
  Before posting a performance problem please read[/url]

• thundersplash845

  SSC Eights!

  Points: 957

  More actions

  November 28, 2011 at 10:11 pm

  #1413767

  Thanks for your reply.

  I applied below syntax to get the result:

  dateAdd(hour,(datediff(hour, getdate(),getutcdate())-1), getdate())

  I also wanted to get UTC today's midnight datetime ...How do i get that??