Dotnet Programing
It provides the solution of any query about C# windows forms, Asp.net,HTML,CSS,Sql Server
Pages
Home
C# Interview Questions & Answers
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment