Many Many Thanks, It's working :) , Best Regards, Iyad
On 8 June 2010 14:06, ddf <orat...@msn.com> wrote: > > > On Jun 8, 4:21 am, Iyad Bacdounes <iya...@gmail.com> wrote: > > Hello, > > > > I have table with column FIRST_DATE contain date data > > but the data type of this column is NUMBER(19) > > > > is it possible to convert it to date ?? > > > > *FIRST_DATE* 1256079902759 1261351075138 1264031290994 1263081389427 > > 1263081386807 1233058735800 1261352573131 1250810075236 1261352632195 > > > > -- > > Best Regards, > > > > Iyad > > SQL> create table unix_time(first_date number); > > Table created. > > SQL> > SQL> insert all > 2 into unix_time > 3 values(1256079902759) > 4 into unix_time > 5 values(1261351075138) > 6 into unix_time > 7 values(1264031290994) > 8 into unix_time > 9 values(1263081389427) > 10 into unix_time > 11 values(1263081386807) > 12 into unix_time > 13 values(1233058735800) > 14 into unix_time > 15 values(1261352573131) > 16 into unix_time > 17 values(1250810075236) > 18 into unix_time > 19 values(1261352632195) > 20 select * from dual; > > 9 rows created. > > SQL> > SQL> select (timestamp '1970-01-01 00:00:00 CST' + > 2 numtodsinterval(first_date/1000, 'SECOND')) > 3 at time zone 'US/Central' > 4 from unix_time > 5 / > > (TIMESTAMP'1970-01-0100:00:00CST'+NUMTODSINTERVAL(FIRST_DATE/ > 1000,'SECOND') > --------------------------------------------------------------------------- > 21-OCT-09 12.05.02.759000000 AM US/CENTRAL > 20-DEC-09 11.17.55.138000000 PM US/CENTRAL > 20-JAN-10 11.48.10.994000000 PM US/CENTRAL > 09-JAN-10 11.56.29.427000000 PM US/CENTRAL > 09-JAN-10 11.56.26.807000000 PM US/CENTRAL > 27-JAN-09 12.18.55.800000000 PM US/CENTRAL > 20-DEC-09 11.42.53.131000000 PM US/CENTRAL > 21-AUG-09 12.14.35.236000000 AM US/CENTRAL > 20-DEC-09 11.43.52.195000000 PM US/CENTRAL > > 9 rows selected. > > SQL> > > David Fitzjarrell > > -- > You received this message because you are subscribed to the Google > Groups "Oracle PL/SQL" group. > To post to this group, send email to Oracle-PLSQL@googlegroups.com > To unsubscribe from this group, send email to > oracle-plsql-unsubscr...@googlegroups.com > For more options, visit this group at > http://groups.google.com/group/Oracle-PLSQL?hl=en > -- Best Regards, Iyad -- You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to Oracle-PLSQL@googlegroups.com To unsubscribe from this group, send email to oracle-plsql-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en
