Menu

#39 PostgreSQL quoting of datetime and time broken

closed-works-for-me
Postgres (36)
5
2005-03-01
2004-09-06
No

Passing datetime to sqlrepr results in truncation of the time
portion. Passing a time to sqlrepr results in corruption.

>>> sqlrepr(datetime(2003, 12, 4, 13, 45, 50), 'postgres')
"'2003-12-04'"
>>> sqlrepr(date(2003, 12, 4), 'postgres')
"'2003-12-04'"
>>> sqlrepr(time(13, 45, 50), 'postgres')
"'13:45:-1'"

Discussion

  • Oleg Broytman

    Oleg Broytman - 2005-03-01
    • status: open --> closed-works-for-me
     
  • Oleg Broytman

    Oleg Broytman - 2005-03-01
    • milestone: 293287 --> SQLObject_from_repository
    • assigned_to: nobody --> phd
     

Log in to post a comment.