GETUTCDATE()

• fasttrack

  SSCertifiable

  Points: 6071

  More actions

  January 30, 2007 at 2:38 am

  #194116

  Hi everybody,

  I have this small request:

  If I run GETUTCDATE(), I get the UTC time with time at the end, like

  yyyy-mm-dd hh:mm:ss:ms.

  I would like to have UTC without sec and ms, like:

  yyyy-mm-dd hh:mm

   

  Do you know how the get this in a fast way (indeopendent from reginal settings)

   

  Thank a lot

• Prasad Bhogadi

  SSCrazy Eights

  Points: 9235

  More actions

  January 30, 2007 at 2:53 am

  #686378

  SELECT CAST(GETUTCDATE() AS SMALLDATETIME)

  SELECT CONVERT(VARCHAR(16),GETUTCDATE(),20)

  Prasad Bhogadi
  www.inforaise.com

• fasttrack

  SSCertifiable

  Points: 6071

  More actions

  January 30, 2007 at 4:15 am

  #686396

  Thank a lot