# 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

My Personal Notes arrow_drop_up