in reply to Class::DBI / Oracle date field Q

In my tests this worked fine:
my $sql = qq[
    UPDATE foo_table
    SET    foo_date =  to_date( '03/03/2004', 'MM/DD/YYYY' )
    WHERE  id = 1
];

[download]
 update
Sorry, I didn't read your question correctly.

pelagic

Replies are listed 'Best First'.
Re: Re: Class::DBI / Oracle date field Q
by Anonymous Monk on May 07, 2004 at 08:07 UTC
    How? That's just a scalar variable. The SQL it contains may work on its own, but it won't in the OPs context.
[reply]
      There might be a straightforward way, however the workaround will be to issue sql alter session set nls_date_format='DD/MON/YYYY'; and then your insert/update.
[reply]
[d/l]

In Section Seekers of Perl Wisdom