Function to parse psql timestamp

Question

I display the date or the time on my website a lot and I'm thinking about writing a function to parse a PostgreSQL timestamp.

The timestamp is in the format: Y-m-d H:i:s.u. E.g. 2011-04-08 23:00:56.544.

I'm thinking about something like this:

function parse_timestamp($timestamp, $format = 'd-m-Y')
{
    // parse the timestamp

    return $formatted_timestamp;
}

However I am wondering whether this can also be achieved without writing a parser for it myself (with the use of some PHP function).

Answer 1

function parse_timestamp($timestamp, $format = 'd-m-Y')
{
    return date($format, strtotime($timestamp));
}

Don't forget to set timezone before, e.g.

date_default_timezone_set('UTC');

Or in your case, I guess 'Europe/Amsterdam'.

You can always get PHP timestamp of this format Y-m-d H:i:s.u using strtotime(). Then, using date() you can export time in your own format. Both functions depend of time zone set.