[patdev]

Hi all,

i have column dataty with number and i would like to convert to date but not getting any success:

I have 20080625092308000 and would like to convert to 2008/06/25 and rest needs to be ignored:

Thanks
Pat

[Littlefoot]

With a little help of the SUBSTR and TO_DATE functions, you might do it as following:

SQL> select to_date(substr('20080625092308000', 1, 8), 'yyyy/mm/dd') result
  2  from dual;

RESULT
----------
25.06.2008

SQL>

[patdev]

thanks a lot for help

[beilstwh]

Since it is a number, this would also work

select to_date(to_char(floor(20080625092308000/1000000000)), 1, 8), 'yyyymmdd') result  
  from dual;