Skip navigation
Contact Us
10688 Views 5 Replies Latest reply: Sep 20, 2011 1:22 PM by Tomislav Krizan RSS
Arnab Kumar Patra Novice 27 posts since
Jan 10, 2011
Currently Being Moderated

Mar 21, 2011 4:25 AM

How to convert 'date(CCYYMMDD)' format into 'date(YYYYMMDD)' format

Hi All,

 

     I have requirement where I have to convert the date format from 'CCYYMMDD' to 'YYYYMMDD'. Eg: '21060716' to '20060716' or '20980515' to '19980515'.

 

     Please provide some solution for this.

 

Note: Input is a .dat file and output is Oracle DB.

 

     Thanks in advance.

More Like This

  • Retrieving data ...

Bookmarked By (1)

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points