in reply to Wrong time issue help!

This is a database issue.

What database are you using? How are you inserting that value into the db?

Please read How do I post a question effectively?.

Replies are listed 'Best First'.
Re^2: Wrong time issue help!
by Anonymous Monk on Jun 09, 2011 at 02:31 UTC
    Here simple as this, MySql Database, the field "date_in" is set as type datetime.
    ... my $datetime = sprintf("%4d-%02d-%02d %02d:%02d:%02d.000",Today_and_No +w()); ... my $sth = $dbh->prepare("INSERT INTO mytable(name,date_in) values(?,?) +") ,$dbh->errmsg); $sth->execute($name,$datetime); ...
    Thanks