Wednesday, May 14, 2014

Get datetime as per GMT in SQL Server



DECLARE @ToDay datetime
              SET  @ToDay =CAST(( SWITCHOFFSET(SYSDATETIMEOFFSET(), '+05:30') ) AS SMALLDATETIME)

No comments:

Post a Comment