Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
How to convert Python date format to 10-digit date format for mysql?
In this article, we will convert a python date format to 10-digit format for MySQL. We use the mktime() method from the time module provided by python.
The mktime() method
The python time method mktime() is the inverse function of the localtime().
The time.mktime() method of the Time module is used to convert a time.struct_time object or a tuple of 9 elements(which represents the time.struct_time object) to time in seconds since the epoch of the local system.
Syntax
The syntax of mktime() method is as follows.
Time.mktime(t)
Where, t is a time.struct_time object or a tuple containing 9 elements corresponding to the time.struct_time object.
If the input value does not represent a valid time, either Overflow Error or Value Error will be raised.
If the date is in the form of a datetime object
If the date is in the form of a datetime object, then you can directly get the time tuple for that object and pass it to the time.mktime() function.
Example 1
In this example, we will check if the date given is in the form of the datetime object.
import time from datetime import date from datetime import datetime my_date = date.today() my_date = my_date.timetuple() print("Time tuple:",my_date) print(time.mktime(my_date))
Output
On executing the above program, the following output is obtained.
Time tuple: time.struct_time(tm_year=2022, tm_mon=5, tm_mday=19, tm_hour=0, tm_min=0, tm_sec=0, tm_wday=3, tm_yday=139, tm_isdst=-1) 1652898600.0
Example 2
Let us look at another example of this −
import datetime import time my_date = datetime.datetime(2020, 5, 17) print(time.mktime(my_date.timetuple()))
Output
This will give the output −
1589673600.0
If the date is in the form of a string
Here if the date is in the form of a string, we can parse the string using the strptime() method. And then we use the time.mktime() function to create a MySQL supported date format.
Example
In the following example code, we use the strptime() method to get the time object and time.mktime() method to convert in MySQL date format.
import time my_time = time.strptime("01-01-18", "%d-%m-%y") print(time.mktime(my_time))
Output
The output is as follows.
1514745000.0
Using the strftime()
The strftime() method in python accepts a format string and converts the contents of the current date-time object accordingly, and returns the result in the form of a string.
If you pass '%s' as the format string, this method converts the date-time value into milliseconds and returns the result as a 10-digit value.
Example
Let us look into an example of this −
import datetime date_time = datetime.datetime(2021, 10, 17) digitVal = date_time.strftime('%s') print(digitVal)
Output
1634428800
Using the timestamp() method
The timestamp() method of python returns the time value since the epoch time (1st January 1970) in seconds.
In the following example we are converting the date “17-10-2021” in to 10 digit value using the timestamp() method −
Example
import datetime date_time = datetime.datetime(2021, 10, 17) digitVal = date_time.timestamp() print(digitVal)
1K+ Views
