Home » Infrastructure » Unix » Re: awk / sed
Re: awk / sed [message #96988] Thu, 11 October 2001 06:27
Sanjay Bajracharya
Messages: 279
Registered: October 2001
Location: Florida
Senior Member
Instead of using awk/sed, convert the date '19990921' into a Oracle date on the fly with to_date.

test:

select to_char(to_date('19990921','YYYYMMDD'), 'DD-Mon-YYYY') from dual

will give '21-Sep-1999'

----------------------------------------------------------------------
Previous Topic: UNIX timestamp to DATE
Next Topic: Re: 8.1.7 installation on Redhat 7.1
Goto Forum:
  


Current Time: Wed Jan 27 14:22:58 CST 2021