Re: UTC date conversion

In article <38F3A023.38B3C03A_at_americasm01.nt.com>,   "Walker, Barry (EXCHANGE:CAR:5J42)" <bwalker_at_americasm01.nt.com> wrote:
> HI..i have a UTC time value in a varchar field...on a select how do i
> convert this value to a date such a dd-Month-yy hh:mm
>
> --
> Barry Walker
>

What is a UTC time value?

Here is some sql to convert an Oracle Date to a number where the number is a reference from some starting date and back like in 'C'.

rem
rem Convert Oracle date to number of seconds since reference date rem
select to_number(sysdate - to_date('01-JAN-1970','DD-MON-YYYY'))

• (24 * 60 * 60) "C Time" from sys.dual / rem rem Convert from number of seconds since reference date to Oracle date rem select to_char(to_date('01-JAN-1970','DD-MON-YYYY') + ( &no_sec_since_70 / (60 * 60 * 24) ),'DD-MON-YYYY HH24:MI:SS') "New Date" from sys.dual /

If this is not helpful please re-post with an explanation.

--
Mark D. Powell  -- The only advice that counts is the advice that
 you follow so follow your own advice --


Sent via Deja.com http://www.deja.com/
Before you buy.