Problem displaying PostgreSQL timestamp in PHP

pablogosse

Hi all. I'm selecting a PostgreSQL timestamp field, converting it to a unix timestamp, and then formatting it using the date() function. Here's the code:

echo $d->fields['last_mod']." - ".date("d/m/y g:m:s A",strtotime($d->fields['last_mod']));

Here's a url with the output:
http://waddington.unbc.ca/date_test.php

The problem:
It all formats properly except the minutes. For some reason the minutes are different when formatted in PHP on the right than they are in the PostgreSQL timestamp on the left.

This is the result:

     timestamp         php formatted date
2002-10-13 18:20:15 - 13/10/02 6:10:15 PM
2002-10-13 18:22:24 - 13/10/02 6:10:24 PM

As you can see in the php formatted date the minutes for both records show up as 10, when by the timestamps you can see they are clearly 20 and 22, respectively.

Does anyone have any idea what could possibly be causing this? I'm completely stumped.

Thanks in advance,
Pablo

rrijnders

The way you are doing it is very dependent on locale and format settings in both PHP and PostgreSQL in order to be successful. I find it is safer to do use the getdatepart() function to extract the data from the database timestamp, then use those parts do what I need:

 
// extract the parts from the database retrieved timestamp ("last_used")
$CC = getdatepart($this->last_used, "CC");
$YY = getdatepart($this->last_used, "YY");
$YEAR = $CC.$YY;
$MM = getdatepart($this->last_used, "MM");
$DD = getdatepart($this->last_used, "DD");
$HH = getdatepart($this->last_used, "HH");
$MN = getdatepart($this->last_used, "MN");
$SS = getdatepart($this->last_used, "SS");

// then if I need to create a PHP timestamp for something...
$newtimestamp = mktime($HH, $MN, $SS, $MM, $DD, $YEAR);

pablogosse

Heh heh. Actually, it was a problem in the formatting. I'd looked at it so much I couldn't see it.

echo $d->fields['last_mod']." - ".date("d/m/y g:m:s A",strtotime($d->fields['last_mod']));

Note that the months and the minutes are both the same!!!! Stupid mistake.