Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: SQL
Expertise: Beginner
Oct 24, 2003

Time Conversion GMT to Current Time and Back

When you're working in several time zones, you need to save date values in a common format—the most obvious one being GMT. The following stored procedures store datetime in GMT and retrieve date in current PC datetime.

/*Convert Datetime to GMT
Time Format
Author :PPG Dinesh Asanka
Date :2003-08-23
*/

CREATE PROCEDURE [dbo].[Convert_DateTime_to_GMT]
@dt_Date_Time as datetime
AS
select DATEADD ( hh ,  (DATEDIFF ( hh , GetDate(), GetUTCDate() )) ,
@dt_Date_Time )
GO

/*Convert GMT to Datetime
Time Format
Author :PPG Dinesh Asanka
Date :2003-08-23
*/

CREATE PROCEDURE [dbo].[Convert_GMT_to_DateTime]
@dt_GMT as datetime
AS
select DATEADD ( hh ,  (DATEDIFF ( hh , GetUTCDate(),GetDate() )) ,
@dt_GMT )
GO
Heres a sample:

declare @dt  nvarchar(20)
Select  @dt =  cast('2003/10/12 13:12' as datetime)
exec Convert_GMT_to_DateTime @dt
Dinesh Asanka
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date