Newbie timestamp question

Поиск
Список
Период
Сортировка
От Robin 'Sparky' Kopetzky
Тема Newbie timestamp question
Дата
Msg-id BAENJGGPMHPCLAKAEPHAEENMCCAA.sparkyk@blackmesa-isp.net
обсуждение исходный текст
Ответы Re: Newbie timestamp question
Re: Newbie timestamp question
Re: Newbie timestamp question
Список 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 по дате отправления:

Предыдущее
От: Bill Moran
Дата:
Сообщение: Re: Relation "xxxxx" does not exist - more info
Следующее
От: "Valter"
Дата:
Сообщение: Re: Relation "xxxxx" does not exist - more info