CODEWITHSUNDEEP
perl
Bdfy
Bdfy

Reputation: 24699

How to convert text date to timestamp?

How to convert date in text format:

23.10.2011  11:35:00

to timestamp ?

Upvotes: 18

Views: 48025

Answers (4)

x-yuri
x-yuri

Reputation: 18923

Not sure why the Time::Piece answer was deleted. Maybe because it (Time::Piece) has its quirks. But it's more powerful than Date::Parse (although less powerful than DateTime, but some say it covers most of the needs), it's a core module, and you don't have to parse the string as with Time::Local. But datetime math is apparently not DST-safe.

Long story short:

use Time::Piece;
my $tp = Time::Piece->strptime("23.10.2011  11:35:00", 
                               "%d.%m.%Y  %H:%M:%S");
# or this way (if the timestamp is in the local time zone):
# $tp = localtime->strptime("23.10.2011  11:35:00",
#                           "%d.%m.%Y  %H:%M:%S");
print $tp;

More on creating Time::Piece objects here.

Upvotes: 0

HOST-X
HOST-X

Reputation: 443

Using Date::Parse in Perl is very elegante option too. Maybe someone will found this useful:

$gmtdate = 'Jul 12 00:12:26 2021 GMT';
my $timestamp = str2time($gmtdate);

Upvotes: 1

gpojd
gpojd

Reputation: 23075

I'd look into DateTime and the parsing modules. 

perl -MDateTime::Format::Strptime -le'$strp = DateTime::Format::Strptime->new( pattern => "%d.%m.%Y  %T", time_zone => "local"); $dt = $strp->parse_datetime("23.10.2011  11:35:00"); print $dt->epoch'
1319384100 at -e line 1.

Same as above, but not a one-liner:

use DateTime::Format::Strptime;
my $strp = DateTime::Format::Strptime->new(
   pattern => '%d.%m.%Y  %T',
   time_zone => 'local',
);
my $dt = $strp->parse_datetime('23.10.2011  11:35:00');
print $dt->epoch;

Upvotes: 18

Toto
Toto

Reputation: 91488

Using Time::Local , you can do:

use Time::Local;

my $date = '23.10.2011  11:35:00';
my ($mday,$mon,$year,$hour,$min,$sec) = split(/[\s.:]+/, $date);
my $time = timelocal($sec,$min,$hour,$mday,$mon-1,$year);
print $time,"\n",scalar localtime $time;

Output:

1319362500
Sun Oct 23 11:35:00 2011

Upvotes: 21

Related Questions