in reply to Problem passing date to SQL

If the previous suggestion does not work, in order to make sure the module is interpreting your data as you intend, you might want to do something like:

use DBI qw(:sql_types);
...
$sth->bind_param( 1, $date, SQL_VARCHAR );
$sth->execute();
...

[download]
Dum Spiro Spero

Replies are listed 'Best First'.
Re^2: Problem passing date to SQL
by JoeTheProgrammer (Novice) on Aug 18, 2015 at 15:27 UTC
    I was just reading up on bind_param and the different placeholders DBD::Oracle supports. I'll try this out and see if it works. :)
[reply]

In Section Seekers of Perl Wisdom