WHAT IS EQUIVALENT OF ORACLE'S LOCALTIMESTAMP() IN SQL SERVER 2005

• sachin.s.joshi

  SSC Enthusiast

  Points: 163

  More actions

  July 22, 2008 at 2:15 am

  #93604

  Dear All,

  I need the equivalent functionality of Oracle's LOCALTIMESTAMP() in SQL Server 2005.

  Please help me.

  Thanks in advance..

• SwePeso

  SSC-Dedicated

  Points: 39757

  More actions

  July 22, 2008 at 2:49 am

  #846226

  GETDATE() or GETUTCDATE()

  ---

  N 56°04'39.16"
  E 12°55'05.25"