Convert string into DateTime to UTC format in Python, postgresql

Question

I receive 2 different formats of datetime in string format. But While storing in PostgreSql Database it has to be stored in UTC format.

Format 1 : 2017-08-25 01:10:56.910523 -04:00
Format 2 : 2017-08-25 01:10:56.910523 AMERICA/NEW_YORK

Tried using timestamptz in PostgreSql but I guess it doesn't seem to understand AMERICA/NEW_YORK so how can to convert and store in UTC format in DB

-4:00 and AMERICA/NEW_YORK are just example but it can be anything else.

Did you try the dateutil.parser? Here is a link: dateutil.readthedocs.io/en/stable/parser.html It should be not to hard to parse the timezone information and reformat it. Edit: it's actually from dateutil.tz import gettz — Jan Zeiseweis
– Jan Zeiseweis, Commented Aug 30, 2017 at 10:45
for gettz i need to know the timezone right so should I parse the string and get the timezone from it — Sharath
– Sharath, Commented Aug 30, 2017 at 10:52

Jan Zeiseweis · Accepted Answer · 2017-08-30 12:15:15Z

3

I'd do something like this: First try to parse it altogether, if this fails parse it separately.

from dateutil import parser, tz
utc_tz = tz.gettz('UTC')

times = ['2017-08-25 01:10:56.910523 -04:00',
         '2017-08-25 01:10:56.910523 AMERICA/NEW_YORK']

for t in times:
    try:
        utc_time = parser.parse(t).astimezone(utc_tz)
    except ValueError as e:
        _date, _time, _tz = t.split(' ')
        _time_wo_tz = parser.parse(' '.join([_date, _time]))
        _parsed_tz = tz.gettz(_tz.title())
        _time_w_tz = _time_wo_tz.replace(tzinfo=_parsed_tz)
        utc_time = _time_w_tz.astimezone(utc_tz)

    print(utc_time)

edited Aug 30, 2017 at 12:15

answered Aug 30, 2017 at 11:19

Jan Zeiseweis

3,7482 gold badges19 silver badges24 bronze badges

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

6 Comments

Sharath Over a year ago

_parsed_tz = tz.gettz(_tz) is giving None for AMERICA/NEW_YORK. Since its none it crashes in catch block

Jan Zeiseweis Over a year ago

@Sharath are you running this on a windows machine?

Sharath Over a year ago

I am using Ubuntu 16.04

Sharath Over a year ago

I tried hard coding it print(tz.gettz('AMERICA/NEW_YORK')) so it gives None

Jan Zeiseweis Over a year ago

Can you try it with 'America/New_York'? If that works, add .title() to _tz. (see updated answer).

|

Collectives™ on Stack Overflow

Convert string into DateTime to UTC format in Python, postgresql

1 Answer 1

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related