in reply to Re: inserting date into mysql
in thread inserting date into mysql

Spot-on! (AnomalousMonk ++)

This modification fixes the problem:

my $trade_dt=UnixDate($x=~/([\/\d]+)/,qq|%Y-%m-%d|);
(Assuming you are using UnixDate from Date::Manip)
UnixDate silently returns undef when provided a quoted value.

            "XML is like violence: if it doesn't solve your problem, use more."