how do i convert  a date type ddmmyy to ccyy-mm-dd

tafadzwa02
tafadzwa02 used Ask the Experts™
on
I am tyring to convert date type in informatica from DDMMYY TO ccyy-mm-dd . its urgent can you plase help.

Thank you
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
to_char(your_dt,'ccyy-mm-dd');
 

haven't got access to test the cc yet - so go with

to_char(your_dt,'yyyy-mm-dd')

put a to_date round that if you need it back in date format for any reason.

Production Manager / Application Support Manager
Commented:
Try this :

select to_char(to_date('160511','ddmmyy'),'ccyy-mm-dd') from dual
Naveen KumarProduction Manager / Application Support Manager

Commented:
Good and thanks.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial