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

From: Ron Levenberg <ral_at_cc.bellcore.com>
Date: 1996/01/29
Message-ID: <4eolfr$jqa_at_athos.cc.bellcore.com>#1/1


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 Received on Mon Jan 29 1996 - 00:00:00 CET

Original text of this message