TIME ZONE

[JK]

Hi
Is their any function available in SQL SERVER like New_function() in Oracle.
This function use to convert time from one Zone to another Zone. i.e Easter time zone to Pacific time Zone.


Thanks and appreciate your Help

JK

[hiku]

Hey JK,
As far as I know I do not think SQL has any time zones. Oracle has plenty.
In one of my applications I needed GMT(Greenwich Meriddian Time) I ended up
catching systemdate and then using dateadd function.you can set the whole thing as default. "dateadd(hh,6,getdate())". However if your application is for U.S you also have to take into consideration day light saving time.
Hth
Hiku
------------
JK at 1/19/01 5:03:29 PM

Hi
Is their any function available in SQL SERVER like New_function() in Oracle.
This function use to convert time from one Zone to another Zone. i.e Easter time zone to Pacific time Zone.


Thanks and appreciate your Help

JK

[JK]

Hi Hiku,
Thanks very much.

JK



------------
hiku at 1/22/01 11:01:25 AM


Hey JK,
As far as I know I do not think SQL has any time zones. Oracle has plenty.
In one of my applications I needed GMT(Greenwich Meriddian Time) I ended up
catching systemdate and then using dateadd function.you can set the whole thing as default. "dateadd(hh,6,getdate())". However if your application is for U.S you also have to take into consideration day light saving time.
Hth
Hiku
------------
JK at 1/19/01 5:03:29 PM

Hi
Is their any function available in SQL SERVER like New_function() in Oracle.
This function use to convert time from one Zone to another Zone. i.e Easter time zone to Pacific time Zone.


Thanks and appreciate your Help

JK