in reply to timestamp in perl

That is impossible, either both should work, or neither one should

You say that the strftime one works, that must mean you're giving the wrong variable to $sth->execute

Replies are listed 'Best First'.
Re^2: timestamp in perl
by baperl (Sexton) on Sep 24, 2011 at 17:42 UTC
    well, what I said is that when I enter at the commandline 2011-09-19 12:30:01 (i.e. not localtime), then in the table it gets inserted as 2011-09-19 00:00:00 instead of 2011-09-19 12:30:01 which I want it to insert. of course strftime works, but that only gives me current date and time...I want to enter past date and time. hope that clarifies
[reply]
      ... when I enter 2011-09-22 12:30:01 at the commandline ...

      baperl:
      You do not show in the OP exactly what you are entering at the command line, and the Devil is in the details.

      If you enter something like
          perl myscript.pl 2011-09-22 12:34:56 19.95
      then  $ARGV[0] will be '2011-09-22' and  $ARGV[1] will be '12:34:56' (and  $ARGV[2] will be '19.95' – the price?).

      Try printing exactly what  $ARGV[0] is:
          print qq{'$ARGV[0]'};
      or maybe quoting the date-and-time on the command line: '2011-09-22 12:34:56' (of course, use double-quotes for Windoze).

[reply]
[d/l]
[select]
        yes indeed, you're right...that was the mistake I was making...thx!
[reply]

In Section Seekers of Perl Wisdom