Gossamer Forum: General: Perl Programming: Convert yyyy-mm-dd format into UNIX timestamp...

Sep 21, 2005, 3:23 AM

Andy

Veteran / Moderator (18441 posts)

Sep 21, 2005, 3:23 AM

Post #1 of 4

Shortcut

Convert yyyy-mm-dd format into UNIX timestamp...

Hi,

I'm trying to convert a normal date (i.e yyyy-mm-dd), into a UNIX timestamp. Thus far, I have;

date_transform ($date, '%yyyy%-%mm%-%dd%', '%yyyy%%m%%dd%%H%%MM%%ss%');

...but that doesn't seem to work right :/

Any ideas? Smile

TIA

Andy (mod)
andy@ultranerds.co.uk

Sep 21, 2005, 4:54 AM

Volker

Novice (23 posts)

Sep 21, 2005, 4:54 AM

Post #2 of 4

Shortcut

Re: [Andy] Convert yyyy-mm-dd format into UNIX timestamp... In reply to

Do you mean unixtime or timestamp?

You can't simply convert a date to unixtime by changing the format string since it needs to be converted into the seconds that have passed after 1970. This function will do the conversion:

Code:
sub { 
  my $year = 2005; 
  my $month = 9; 
  my $day = 21; 

  use Time::Local; 
  my $time = timelocal(0,0,0,$day,$month,$year); 
  return $time; 
}

Sep 22, 2005, 2:47 AM

Volker

Novice (23 posts)

Sep 22, 2005, 2:47 AM

Post #3 of 4

Shortcut

Re: [Volker] Convert yyyy-mm-dd format into UNIX timestamp... In reply to

Bugfix:

Code:
sub {  
  my $year = 2005;  
  my $month = 9;  
  my $day = 21;  

  use Time::Local;  
  my $time = timelocal(0,0,0,$day,$month - 1,$year);  
  return $time;  
}

Sep 24, 2005, 12:50 AM

Andy

Veteran / Moderator (18441 posts)

Sep 24, 2005, 12:50 AM

Post #4 of 4

Shortcut

Re: [Volker] Convert yyyy-mm-dd format into UNIX timestamp... In reply to

Thanks =)

In Reply To:

Bugfix:

Code:
sub {  
  my $year = 2005;  
  my $month = 9;  
  my $day = 21;  

  use Time::Local;  
  my $time = timelocal(0,0,0,$day,$month - 1,$year);  
  return $time;  
}

Andy (mod)
andy@ultranerds.co.uk