I am trying to insert a date (timestamp variable in mySQL) into mySQL table.
the date is entered at the commandline so it is ARGV in my Perl code.
the issue is when I enter 2011-09-22 12:30:01 at the commandline, the sql table shows 2011-09-22 00:00:00.
here's the relevant part of the code:
my $t_dt = $ARGV ;
my $t_price = $ARGV ;
my $ins_r = "INSERT INTO $tbl_name (t_dt, t_price) VALUES (?,?);";
$sth=$dbh->prepare($ins_r) or die $dbh->errstr;
so, for testing, I replaced $t_dt with the below, and it shows the current date and time in the table as it should, but since I am dealing with past dates, I can't use the below.
my $t_dt=strftime('%Y-%m-%d %H:%M:%S',localtime);
how can I format my $t_dt so when I enter a previous date(and time) at the commandline it gets inserted correctly into mySQL.