[ask] oracle date

dear list,
I have a date data extracted from oracle, stored as this 1993-11-30
00:00:00. The datatype in the oracle is date. I would like to save into
mysql (the datatype is also date), I got an error. When I do a small
debug, I print the date directly, it comes out into 30-NOV-93. I am
trying to use date::manip, time::format, date::format, it still got an
error and cannot be saved into mysql.

Please help to tell me how to convert the date format and can be stored
into mysql. Thanks.


Eko

From: "Eko Budiharto" <eko.budiharto@gmail.com>
Subject: [ask] oracle date





After you connect to Oracle, you need to send the following sql queries in order to changed the format in which it returns the date fields:

alter session set nls_date_format = 'YYYY-MM-DD HH24:MI:SS';
alter session set nls_timestamp_format = 'YYYY-MM-DD HH24:MI:SS.FF';
alter session set nls_timestamp_tz_format='YYYY-MM-DD HH24:MI:SS.FF TZHTZM';

After you do this, the dates will be returned in the same format as the one used by MySQL, so you don't need any Perl module to parse the date fields.

Octavian