How to get GMT time from SQL server

[adasoft]

Hi all,

How can I get GMT time from SQL server?Any idea about the process which SQL server follows to get UTC dateand time?

With regards,
Adasoft

 

[vongrunt]

Check GETUTCDATE().

 

[adasoft]

Hi,

thanks for the reply.But I know this function.I was asking about the process which is being followed by this procedure to get UTC time.Any idea?If yes then thanx in advance.

 

[vongrunt]

Simple: SQL Server reads local machine time and zone setting, then calculates UTC/GMT.

 

[adasoft]

Hi,

Again thanks.Have u idea about reading local machine time and zone setting and how to calculate UTC/GMT time based on this reading?Please provide me details.

With best regards,

 

[SQLBill]

adasoft,

What are you looking for? As Vongrunt stated, SQL Server does that with GETUTCDATE(), so why is anything else needed? That would be like reinventing the wheel.

If you are looking for a solution besides SQL Server, you need to post in an appropriate forum.

-SQLBill