# 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:

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

• 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

My Personal Notes arrow_drop_up