Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Urgent Query
Hi,
This query
select to_date(CURRENT_DATE,'dd/mm/yyyy hh:mi:ss AM') from dual;
returnig the result as 31/07/0006 while the current year is 2006 ???
plz help Received on Mon Jul 31 2006 - 06:59:11 CDT
![]() |
![]() |