Re: Convert GMT date to PST in 8i

2003-08-14 Thread AK
select new_time(sysdate,'GMT','PST') from dual; -ak - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, August 12, 2003 4:39 PM I need some help to convert a GMT date into PST date and take care of all Day Light saving etc. Is there any

Convert GMT date to PST in 8i

2003-08-14 Thread Anubha Jalsingh
I need some help to convert a GMT date into PST date and take care of all Day Light saving etc. Is there any pre-built function or easy way of doing it. My database version is 8i ( 8.1.7.4) Thanks Manmohan Get advanced SPAM