Re: Q: How to handle the 'date' datatype with Oraperl?

Internal Oracle Date storage includes details upto senconds. The default input/output format can be specified by NLS_DATE_FORMAT (or similar name) parameter in init.ora file. Also look for alter session command to do the same.

ral_at_cc.bellcore.com (Ron Levenberg) wrote:

>I am successfully using the Oraperl emulation (Perl5 + DBI + DBD for
>Oracle), but I've just run up against a bit of a problem: I have a
>bunch of data base fields that are of 'date' datatype. When I
>used Oraperl to do a select, they are returned as strings in the
>format '26-JAN-96', which is the default format for Oracle dates.
>I would like to convert this to a different format, mm/dd/yy or
>mm/yy. Is there anything built into Oraperl for doing this, or
>do I need to write a conversion function?
 

>Thanks - Ron Levenberg ral_at_cc.bellcore.com

--
Balakrishna Avula						28 Ashby Court
Alpha-Tek Associates Ltd.					Hemel Hempstead
Technical Consultant						HERTS HP2 7QL
100610,52 on Compuserve						UK

http://ourworld.compuserve.com/homepages/BAvula/homepage.htm on WWW