Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> Date and time field question
Hello,
I am having problem creating a time and date format,
I will encounter this error message :
"date format picture ends before converting entire input string"
When I change to
2) v_timedate := to_char(sysdate,'DD-MON-YYYY');
It will work fine BUT it will display :
13-APR-00 What happen to the '20' ?
Thanks for any help ! Received on Thu Apr 13 2000 - 00:00:00 CDT
![]() |
![]() |