Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Help with my to_date function
Group,
I need to change a string of 6 in the format of 'yymmdd' to date. If yy< 07, i need to put 20 in front of it. If yy<07, I need to put 19 in front of it.
So,
040102 needs to be 20040102
while
320102 needs to be 19320102.
Thanks for your help. Received on Mon Oct 02 2006 - 08:15:06 CDT
![]() |
![]() |