Re: DBI:mysql date conversion question

Replies are listed 'Best First'.
Re^2: DBI:mysql date conversion question by Anonymous Monk on Sep 22, 2008 at 01:17 UTC
`my $sth = $dbh->prepqre(q~ ( indate, siteid,serial,contract,installdate) values (CURDATE(), ?, ?, ?, STR_TO_DATE(?,'%m/%d/%Y') ) ~); $sth->execute( $frame_siteid, $frame_serial, $frame_contract, $frame_i +nstalldate );` [download]	[reply] [d/l]
Re^3: DBI:mysql date conversion question by ikegami (Patriarch) on Sep 22, 2008 at 03:16 UTC
`my $sth = $dbh->prepqre(q~` [download] should be `my $sth = $dbh->prepare(q~ insert into frame` [download]	[reply] [d/l] [select]
Re^4: DBI:mysql date conversion question by Anonymous Monk on Sep 22, 2008 at 07:10 UTC
I type with heavy accent :D	[reply]