Getting UTC date and fixed time

• ramana3327

  SSCoach

  Points: 19700

  More actions

  May 27, 2015 at 2:26 pm

  #298618

  Hi,

  I am working on some dev task.

  I need to change one of the column to run utctime 2am. Whenever I declared and set the time, it has to run and set up to the UTC 2 am time.

  How to declare the variable like that?

  If I run that now, it has to set up next utc 2 am time, If I run after 2 hrs also or tomorrow whenvever, it has to set the next utc 2am time

• Eric M Russell

  SSC Guru

  Points: 125518

  More actions

  May 27, 2015 at 2:58 pm

  #1801102

  GETDATE() returns local time and GETUTCDATE() returns UTC time.

  "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho