Convert string date to timestamp in Python

Question

How to convert a string in the format   d  m  Y  to timestamp    01 12 2011  - gt  1322697600

User · Answer

Seems to be quite efficient   import datetime day  month  year    01 12 2011  split      datetime datetime int year   int month   int day   timestamp     1 61   s    120 ns per loop  mean    std  dev  of 7 runs  100000 loops each

User · Answer

A lot of these answers don t bother to consider that the date is naive to begin with  To be correct  you need to make the naive date a timezone aware datetime first  import datetime import pytz   naive datetime d   datetime datetime strptime  01 12 2011     d  m  Y    gt  gt  gt  datetime datetime 2011  12  1  0  0     add proper timezone pst   pytz timezone  America Los Angeles   d   pst localize d   gt  gt  gt  datetime datetime 2011  12  1  0  0  tzinfo  lt DstTzInfo  America Los Angeles  PST-1 day  16 00 00 STD gt      convert to UTC timezone utc   pytz UTC d   d astimezone utc   gt  gt  gt  datetime datetime 2011  12  1  8  0  tzinfo  lt UTC gt      epoch is the beginning of time in the UTC timestamp world epoch   datetime datetime 1970 1 1 0 0 0 tzinfo pytz UTC   gt  gt  gt  datetime datetime 1970  1  1  0  0  tzinfo  lt UTC gt      get the total second difference ts    d - epoch  total seconds    gt  gt  gt  1322726400 0   Also   Be careful  using pytz for tzinfo in a datetime datetime DOESN T WORK for many timezones  See datetime with pytz timezone  Different offset depending on how tzinfo is set    Don t do this  d   datetime datetime 2011  12  1 0 0 0  tzinfo pytz timezone  America Los Angeles     gt  gt  gt  datetime datetime 2011  1  12  0  0   tzinfo  lt DstTzInfo  America Los Angeles  LMT-1 day  16 07 00 STD gt     tzinfo in not PST but LMT here  with a 7min offset        when converting to UTC  d   d astimezone pytz UTC   gt  gt  gt  datetime datetime 2011  1  12  7  53  tzinfo  lt UTC gt     you end up with an offset   https   en wikipedia org wiki Local mean time

User · Answer

just use datetime timestamp your datetime instanse   datetime instance contains the timezone infomation  so the timestamp will be a standard utc timestamp  if you transform the datetime to timetuple  it will lose it s timezone  so the result will be error  if you want to provide an interface  you should write like this   int datetime timestamp time instance     1000

User · Answer

I use ciso8601  which is 62x faster than datetime s strptime   t    01 12 2011  ts   ciso8601 parse datetime t    to get time in seconds  time mktime ts timetuple      You can learn more here

User · Answer

You can refer this following link for using strptime function from datetime datetime  to convert date from any format along with time zone   https   docs python org 3 library datetime html strftime-and-strptime-behavior

User · Answer

The answer depends also on your input date timezone  If your date is a local date  then you can use mktime   like katrielalex said - only I don t see why he used datetime instead of this shorter version    gt  gt  gt  time mktime time strptime  01 12 2011     d  m  Y    1322694000 0   But observe that my result is different than his  as I am probably in a different TZ  and the result is timezone-free UNIX timestamp   Now if the input date is already in UTC  than I believe the right solution is    gt  gt  gt  calendar timegm time strptime  01 12 2011     d  m  Y    1322697600

User · Answer

gt  gt  gt  int datetime datetime strptime  01 12 2011     d  m  Y   strftime   s    1322683200

User · Answer

To convert the string into a date object   from datetime import date  datetime  date string    01 12 2011  date object   date  map int  reversed date string split         assert date object    datetime strptime date string    d  m  Y   date     The way to convert the date object into POSIX timestamp depends on timezone  From Converting datetime date to UTC timestamp in Python    date object represents midnight in UTC  import calendar  timestamp1   calendar timegm utc date timetuple    timestamp2    utc date toordinal   - date 1970  1  1  toordinal      24 60 60 assert timestamp1    timestamp2  date object represents midnight in local time  import time  timestamp3   time mktime local date timetuple    assert timestamp3    timestamp1 or  time gmtime      time localtime       The timestamps are different unless midnight in UTC and in local time is the same time instance

User · Answer

A simple function to get UNIX Epoch time   NOTE  This function assumes the input date time is in UTC format  Refer to comments here     def utctimestamp ts  str  DATETIME FORMAT  str     d  m  Y        import datetime  calendar     ts   datetime datetime utcnow   if ts is None else datetime datetime strptime ts  DATETIME FORMAT      return calendar timegm ts utctimetuple      Usage    gt  gt  gt  utctimestamp  01 12 2011   1322697600  gt  gt  gt  utctimestamp  2011-12-01     Y- m- d   1322697600

User · Answer

gt  gt  gt  import time  gt  gt  gt  import datetime  gt  gt  gt  s    01 12 2011   gt  gt  gt  time mktime datetime datetime strptime s    d  m  Y   timetuple    1322697600 0

User · Answer

you can convert to isoformat   my date    2020 08 08  my date   my date replace      -     just to adapte to your question date timestamp   datetime datetime fromisoformat my date  timestamp

User · Answer

Simply use datetime datetime strptime   import datetime stime    01 12 2011  print datetime datetime strptime stime    d  m  Y   timestamp      Result   1322697600   To use UTC instead of the local timezone use  replace   datetime datetime strptime stime    d  m  Y   replace tzinfo datetime timezone utc  timestamp

User · Answer

First you must the strptime class to convert the string to a struct time format    Then just use mktime from there to get your float

User · Answer

I would suggest dateutil   import dateutil parser dateutil parser parse  01 12 2011   dayfirst True  timestamp

[python] Convert string date to timestamp in Python

Examples related to python

Examples related to datetime