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

From: jared <afonit(at)gmail(dot)com>
To: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: plpython timestamp without time zone, showing up as text instead of timestamp
Date: 2014-03-23 16:47:25
Message-ID: CADss3ASRpNszDf81JSaBa5DP0Sb0QsVTJh_DYTav+uYyZ4QSJA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sun, Mar 23, 2014 at 12:11 PM, Adrian Klaver
<adrian(dot)klaver(at)aklaver(dot)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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2014-03-23 18:34:50 Re: plpython timestamp without time zone, showing up as text instead of timestamp
Previous Message Adrian Klaver 2014-03-23 16:11:10 Re: plpython timestamp without time zone, showing up as text instead of timestamp