Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On 03/23/2014 09:47 AM, jared wrote:



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


    Intended:

    http://www.postgresql.org/__docs/9.3/interactive/plpython-__data.html <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
    <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.

Should have added previously, if you use dateutil you can dispense with:

from datetime import datetime, timedelta

and use the relativedelta module from dateutil to do your offsets


--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx


--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux