Python- postgresql timestamp and time without time zone

Question

I have 2 strings which represent:

date- dd/mm/yyyy hh:mm and I need to convert it to timestamp without time zone
start_time/end_tiime- hh:mm:ss and I need to convert it time without time zone

I need to do this in order to add them to a sql query. which looks like this:

sql = '''
    INSERT INTO myTable (date, start_time, end_time)
    VALUES (%s ,%s, %s, %s);'''
params = [timestamp, start_time, end_time]
self.cursor.execute(sql, params)

Do you use ORM (SQLAlchemy, Autumn, etc) or do you use some dbapi module directly, which one (psycopg2, pg8000, etc)? — jfs
– jfs, Commented Oct 24, 2011 at 18:33
I didn't try it but I think you could give psycopg2 Python strings, floats, integers, datetime object and it will convert them by itself to compatible SQL type if not you could register an adapter. There might be complications such as different versions of postgresql treat timestamp with/without time zone types differently, psycopg2 might expose whether postgresql compiled with integers or floats for timestamp, time. You could see what would be sent to the database by calling cursor.mogrify(). — jfs
– jfs, Commented Oct 25, 2011 at 18:17
related: convert timestamp without time zone returned as float by psycopg2 to datetime — jfs
– jfs, Commented Oct 25, 2011 at 20:18

unutbu · Accepted Answer · 2011-10-24 17:30:13Z

2

dd/mm/yyyy hh:mm to timestamp without time zone:

import time

date_string='24/10/2011 12:43'
ttuple=time.strptime(date_string,'%d/%m/%Y %H:%M')
timestamp=time.mktime(ttuple)
# 1319474580.0

hh:mm:ss to time without time zone:

Can you clarify what kind of object is a time?

edited Oct 24, 2011 at 17:30

answered Oct 24, 2011 at 16:41

unutbu

886k197 gold badges1.9k silver badges1.7k bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Ron D. Over a year ago

Please take a look here: postgresql.org/docs/8.2/static/datatype-datetime.html

Ron D. Over a year ago

ok. thanks. If I want it as ISO 8601, without the date, just the time?

unutbu Over a year ago

If you are given a string in hh:mm:ss format as input, what do you want as output?

ftoyoshima Over a year ago

I've tested here, this is returning a timestamp with timezone

Collectives™ on Stack Overflow

Python- postgresql timestamp and time without time zone

1 Answer 1

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related