Timezone Conversions - URGENT

[madan9999]

Hi all,

i have a doubt regarding time conversions between different timezones.

say presently i have a Time which is to be converted from 'PST' to 'UTC'

and the same with others say 'PST/PDT,MST/MDT,EST/EDT' to UTC.

can this be done with any oracle functions, please post me the sql statements if any of u have.

thnx in advance

[arg]

I think NEW_TIME is the function you are looking for. Which version of oracle?
http://www.stanford.ed u/dept/itss/docs/oracle/10g/server.101/b10749/ch4datetime.htm

Hi all,

i have a doubt regarding time conversions between different timezones.

say presently i have a Time which is to be converted from 'PST' to 'UTC'

and the same with others say 'PST/PDT,MST/MDT,EST/EDT' to UTC.

can this be done with any oracle functions, please post me the sql statements if any of u have.

thnx in advance

[madan9999]

I am using Oracle 9i,

can we specify directly say i have 'PST' time, now convert it to 'UTC'...

can this be done in sql statements?

[saravanankm]

Hi

Try This May help U!
UTC Time Zone Same as GMT time Zone.

select to_char(new_tim e(sysdate,'PST' , 'GMT'), 'MM/DD/YY HH:MI AM') FROM dual;


With Regards,
Captain

[saravanankm]

Hi

If U Want More Information to visit this site helpfull for Date Functions.

http://www.unix.org.ua/orelly/oracle/prog2/ch12_02.htm

With Regards,
Captain

[SDBA]

Hi,

Try using the following link...

http://www.devx.com/dbzone/Article/30501/1954?pf=true

This cud help you...

SDBA