Newbie timestamp question

From: "Robin 'Sparky' Kopetzky" <sparkyk(at)blackmesa-isp(dot)net>
To: "PostgreSQL General" <pgsql-general(at)postgresql(dot)org>
Subject: Newbie timestamp question
Date: 2004-03-17 18:52:19
Message-ID: BAENJGGPMHPCLAKAEPHAEENMCCAA.sparkyk@blackmesa-isp.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

Thanks in advance.

Robin Kopetzky
Black Mesa Computers/Internet Services
Grants, NM

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Josh Berkus 2004-03-17 18:53:36 Fwd: Hi Josh... not sure if this qualifies for anything...
Previous Message Bill Moran 2004-03-17 18:46:15 Re: Relation "xxxxx" does not exist - more info