select to_date(first_date, 'j') from sample_table; On 8 июн, 14:21, Iyad Bacdounes <[email protected]> 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
-- You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en
