Developers Archive for the 'ms sql server 2005' Category

Next Entries »

How do I convert local time to UTC (GMT) time?

How do I convert local time to UTC (GMT) time? Thursday, December 21st, 2006

Transact-SQL 
 
In SQL Server 2000 & 2005, you can get the current time in UTC format by using the GETUTCDATE() function: 
SELECT GETDATE() AS CurrentTime, GETUTCDATE() AS UTCTime

Posted in ms sql server 2005 | No Comments »

Next Entries »
All material @ copyrighted by chrisranjana.com. If you want to link to this article you are welcome to do so. Unauthorized publication is strictly prohibited. This developer tutorial website contains articles by Php programmers , Software developers, Mysql programmers and asp c# programmers. This website also contains ajax tutorials and advanced mysql sql stored procedures and functions tutorials and sample codes.