Hi,

Is there any way (if at all an easiest apporach), by which I can get the date from my tables in the format shown below using sql? Date values in table refer to IST, so it needs to be converted to GMT in the format given below. As of now I am doing that from the frontend. This is in SQL 7.0

Fri Sep 13 00:00:00 GMT 2004

Thanks for any help in advance.
Cheers!

_________________________
- Vijay G
Strive for Perfection

__________________
- Vijay G

hai,

sql server 7 dont have to option of GETUTCDATE()
here i am giving a easy solution in sql 2000 which you can extent to sql server 7 by synchronising with the timebase in the registry



SELECT
LEFT(CAST(DATENAME(DW,GETUTCDATE()) AS Varchar),3) +
' '+
LEFT(CAST(DATENAME(MM,GETUTCDATE()) AS VARCHAR),3)+
' '+
RIGHT('00'+CAST(DATEPART(DD,GETUTCDATE()) AS Varchar),2) +
' '+
Right('00' + CAST(DATEPART(HH,GETUTCDATE()) AS Varchar),2)+
':'+
RIGHT('00' + CAST(DATEPART(MI,GETUTCDATE()) AS VARCHAR),2)+
':'+
RIGHT('00' + CAST(DATEPART(SS,GETUTCDATE()) AS VARCHAR),2)+
' GMT '+
CAST(DATEPART(YYYY,GETUTCDATE()) AS VARCHAR)



Happy Tony

Hi Tony,

Thanks. Can you please explain on how do I do that in registry?

Cheers!

_________________________
- Vijay G
Strive for Perfection

hai,

The first thing you have to consider here is the accuracy of the time maintained in your system.So you have to first synchronize your system to the time zone
use the atomic clock to update your system according to the time zone from http://www.worldtimeserver.com/

here i am giving the example to get the GMT time from time zone india- calcutta,new-delhi

select getdate() as systemtime
select dateadd(mi,-330,getdate()) as GMTTIME

hope this will solve your problem

HAPPY TONY

Yes Tony, I was aware of doing it that way. But I was looking for something(if available) that could give me the GMT in the format I was looking for. Now understood that with SQL 7.0, I will have to do the formatting on my own.

Thanks much for the help.
Cheers!

_________________________
- Vijay G
Strive for Perfection