Newbie timestamp question - Mailing list pgsql-general

From Robin 'Sparky' Kopetzky
Subject Newbie timestamp question
Date
Msg-id BAENJGGPMHPCLAKAEPHAEENMCCAA.sparkyk@blackmesa-isp.net
Whole thread Raw
Responses Re: Newbie timestamp question
Re: Newbie timestamp question
Re: Newbie timestamp question
List 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



pgsql-general by date:

Previous
From: Bill Moran
Date:
Subject: Re: Relation "xxxxx" does not exist - more info
Next
From: "Valter"
Date:
Subject: Re: Relation "xxxxx" does not exist - more info