in reply to Re: timestamp in perl
in thread timestamp in perl

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

Replies are listed 'Best First'.
Re^3: timestamp in perl
by AnomalousMonk (Archbishop) on Sep 24, 2011 at 18:03 UTC
    ... 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]
[reply]

In Section Seekers of Perl Wisdom