Change '01/01/1980' date format to to_date('01/01/1980', 'MM/DD/YYYY')

hi,

i have come across this code:

s{(\d{1,2})/(\d{1,2})/(\d{1,4})}{$1-$2-$3}g;

the code is written in perl. it will change date format from 01/01/1980 to 01-01-1980.
I would like to amend it so that is will look for this date format '01/01/1980' (with single quote) and change in to this "to_date('01/01/1980', 'MM/DD/YYYY')" (exclude the double quote)

thanks in advanced.

gagajanice

Asked: 2011-03-03

Advertise Here

1 Solution

LVL 16

sjklein42Commented: 2011-03-03

This should do it:

s{(\d{1,2})/(\d{1,2})/(\d{1,4})}{to_date\('$1/$2/$3\'\, \'MM/DD/YYYY\'\)}g;

Open in new window

gagajaniceAuthor Commented: 2011-03-04

hi sjklein42,

thanks for the reply.
but the result is not what i desire: 'to_date('12/06/2010', 'MM/DD/YYYY')'

i would like to get rid of the single quote '...'.
how to include single quote as part of the date format at the first place.

'01/01/1980' (with single quote) to "to_date('01/01/1980', 'MM/DD/YYYY')" (exclude the double quote)

LVL 16

sjklein42Commented: 2011-03-04

s{\'(\d{1,2})/(\d{1,2})/(\d{1,4})\'}{to_date\('$1/$2/$3\'\, \'MM/DD/YYYY\'\)}g

Open in new window

gagajaniceAuthor Commented: 2011-03-04

thank you so much!

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Expand your skills with this month's free Premium course.

Change '01/01/1980' date format to to_date('01/01/1980', 'MM/DD/YYYY')

Join & Write a Comment Already a member? Login.

Featured Post