Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> beginners question: four digit year

beginners question: four digit year

From: <jdentwickler_at_gmx.de>
Date: Sat, 2 Jun 2001 15:28:20 +0200
Message-ID: <9faq0d$cge$1@ork.backup.noris.net>

Hello !

I hope you can help me:

When select date values from an oracle database I always get the year with two digits displayed.
Of course I can decode the date with the oracle function and an recompose a new date format with a four digit year,
but is there an easy way to confige oracle (8.1.x) to deliver the date always with a four digit year ?

Thank you
J.F.Sebastian Received on Sat Jun 02 2001 - 08:28:20 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US