Hi,
I've run this query:
select to_date(sysdate,'DD/MM/YYYY') DATE_TODAY
from dual
my output is:
DATE_TODAY
2/22/0005
but I'd like to get this output (with 'DD/MM/YYYY' format):
DATE_TODAY
22/2/2005
How Can I change the date format?
Must I change the format server-side?
Thanks




Reply With Quote