Re: plpython timestamp without time zone, showing up as text instead of timestamp

Поиск
Список
Период
Сортировка
От jared
Тема Re: plpython timestamp without time zone, showing up as text instead of timestamp
Дата
Msg-id CADss3ASRpNszDf81JSaBa5DP0Sb0QsVTJh_DYTav+uYyZ4QSJA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: plpython timestamp without time zone, showing up as text instead of timestamp  (Adrian Klaver <adrian.klaver@aklaver.com>)
Ответы Re: plpython timestamp without time zone, showing up as text instead of timestamp  (Adrian Klaver <adrian.klaver@aklaver.com>)
Список pgsql-general



On Sun, Mar 23, 2014 at 12:11 PM, Adrian Klaver <adrian.klaver@aklaver.com> wrote:

Intended:

http://www.postgresql.org/docs/9.3/interactive/plpython-data.html

FYI, it would be a good idea to include the Postgres version. plpython has been undergoing a lot of changes recently, so it would help to peg where you are at in that sequence.

Ah, I see it now:
"All other data types, including the PostgreSQL character string types, are converted to a Python str."
Thanks (as an aside Postgres 9.3 and python 2.7)
 

I find dateutil(https://labix.org/python-dateutil) a handy package to have in this situation. Use parse() from the parser module to do the heavy lifting of converting from a string into a date/datetime object.

I will look into that - thanks again.
 

В списке pgsql-general по дате отправления:

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: plpython timestamp without time zone, showing up as text instead of timestamp
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: plpython timestamp without time zone, showing up as text instead of timestamp