| From: | Richard Huxton <dev(at)archonet(dot)com> |
|---|---|
| To: | "Robin 'Sparky' Kopetzky" <sparkyk(at)blackmesa-isp(dot)net>, "PostgreSQL General" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Newbie timestamp question |
| Date: | 2004-03-17 19:09:20 |
| Message-ID: | 200403171909.20207.dev@archonet.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Wednesday 17 March 2004 18:52, Robin 'Sparky' Kopetzky wrote:
> Good Morning!!
>
> I'm repairing a series of scripts in PHP that use the 'datetime' of MySQL
> and converting them to Postgres. Question is this: The datetime format used
> in the script is 'YYYYMMDDHHMMSS' as a text string. Do I have to convert
> this to the format shown in the Postgres manual: '1999-01-08 04:05:06' for
> Postgres to accept the value or can I just pass an integer as
> 19990108040506 for the timestamp?
You need to pass it a valid timestamp, either in ISO format as you show, or
European/US/... standards (depending on your settings). There's a full list
of formats in the data-types section of the manuals.
--
Richard Huxton
Archonet Ltd
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruno Wolff III | 2004-03-17 19:19:54 | Re: Newbie timestamp question |
| Previous Message | scott.marlowe | 2004-03-17 19:00:55 | Re: Newbie timestamp question |