How to convert NumPy datetime64 to Timestamp?

Last Updated : 02 Sep, 2020

In this article, we will discuss how to convert NumPy datetime64 to Timestamp. For better understanding first, let’s see the below example:

If the current datetime64 is as follows: 2020-08-18 09:31:51.944622
then,
the required timestamp in seconds will be: 1597743111.944622
the required timestamp in minutes will be: 26629051.8657437
the required timestamp in an hour will be: 443817.53109572834

Approach:

Taking date through np.datetime64().
Subtracting that date from default system date that is 1970-01-01T00:00:00Z.
With the help of np.timedelta64() converting the date into seconds, minutes and hour.

Example 1:

Python3

# importing required library
import numpy as np
from datetime import datetime
  
# extracting current date 
# in utc format
date = datetime.utcnow()
  
print("Printing the Current date:",
      date)
  
# converting the current date
# in datetime64 format
date64 = np.datetime64(date)
  
# converting date time into second timestamp 
ts = (date64 - np.datetime64('1970-01-01T00:00:00Z')) / np.timedelta64(1, 's')
  
print("Printing the converted datetime in Timestamp in seconds:",
     ts)
  
# converting date time into minute timestamp 
tm = (date64 - np.datetime64('1970-01-01T00:00:00Z')) / np.timedelta64(1, 'm')
  
print("Printing the converted datetime in Timestamp in minutes:",
     ts)
  
# converting date time into hour timestamp 
th = (date64 - np.datetime64('1970-01-01T00:00:00Z')) / np.timedelta64(1, 'h')
  
print("Printing the converted datetime in Timestamp in hour:",
      th)

Output:

Printing the Current date: 2020-08-26 10:07:54.820878
Printing the converted datetime in Timestamp in seconds: 1598436474.820878
Printing the converted datetime in Timestamp in minutes: 1598436474.820878
Printing the converted datetime in Timestamp in hour: 444010.13189468835

Example2: Converting 15 Aug 2020 in seconds, minutes and hour timestamp:

Python3

#importing required library
import numpy as np
from datetime import datetime
  
print("Printing the date:")
  
# extracting current date in utc format
dt64 = np.datetime64('2020-08-15');
  
print(dt64)
  
# converting date time into second timestamp 
ts = (dt64 - np.datetime64('1970-01-01T00:00:00Z')) / np.timedelta64(1, 's')
print("Printing the converted datetime in Timestamp in seconds:", 
      ts)
print("Printing the converted datetime in Timestamp in minutes")
  
# converting date time into minute timestamp 
tm = (dt64 - np.datetime64('1970-01-01T00:00:00Z')) / np.timedelta64(1, 'm')
print(tm)
  
print("Printing the converted datetime in Timestamp in hour")
  
# converting date time into hour timestamp 
th = (dt64 - np.datetime64('1970-01-01T00:00:00Z')) / np.timedelta64(1, 'h')
print(th)

Output:

Printing the date:
2020-08-15
Printing the converted datetime in Timestamp in seconds:
1597449600.0
Printing the converted datetime in Timestamp in minutes
26624160.0
Printing the converted datetime in Timestamp in hour
443736.0

Attention geek! Strengthen your foundations with the Python Programming Foundation Course and learn the basics.

To begin with, your interview preparations Enhance your Data Structures concepts with the Python DS Course. And to begin with your Machine Learning Journey, join the Machine Learning – Basic Level Course

My Personal Notes

Related Articles

Python3

Python3