Re: timezone problem
| From: | Jouni Ahto | Date: | Sat, 15 Jul 2000 12:16:03 +0000 |
| Subject: | Re: timezone problem | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-6737@lists.php.net to get a copy of this message | ||
On Sat, 15 Jul 2000, Php User wrote:
> when I use strtotime() to convert a postgre timestamp to a UNIX timestamp, the
> milliseconds returned always have 8 hours added into it (my timezone is Taiwan
> which is eight hours away from GMT). Then I try the following:
>
> strtotime(date("l, F j, Y g:ia T"))
> This date() can return the correct date for today but the UNIX timestamp
> returned by strtotime is different from the one returned by microtime().
You could save yourself some time and just ask PostgreSQL to return the
timestamp.
select date_part('epoch', your_column) from your_table;
-- Jouni Ahto