Re: 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?.

Comment on Re: Wrong time issue help!

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); ...` [download] Thanks	[reply] [d/l]

Replies are listed 'Best First'.

Re^2: Wrong time issue help!
by Anonymous Monk on Jun 09, 2011 at 02:31 UTC

...
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);
...
[download]

[reply]
[d/l]