Post reply

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

  • July 22, 2008 at 1:59 am

    #186736

    Dear All,

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

    Please help me.

    Thanks in advance..

  • July 22, 2008 at 2:18 am

    #846210

    I don't have much experience with Oracle, but I think CURRENT_TIMESTAMP would be the T-SQL equivalent of LOCALTIMESTAMP(). Different from the Oracle function the T-SQL version of CURRENT_TIMESTAMP does not contain a timezone.

    [font="Verdana"]Markus Bohse[/font]

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply