Found 10419 Articles for Python

What is the difference between Python functions datetime.now() and datetime.today()?

Rajendra Dharmkar
Updated on 13-Jun-2020 06:04:46

2K+ Views

The function datetime.now() takes tzinfo as keyword argument but datetime.today() does not take any keyword arguments. Quoting the docs −datetime.now() returns the current local date and time. If optional argument tz is None or not specified, this is like today(), but, if possible, supplies more precision than can be gotten from going through a time.time() timestamp (for example, this may be possible on platforms supplying the C gettimeofday() function).

How to convert date and time with different timezones in Python?

Vikram Chiluka
Updated on 25-Aug-2023 01:57:04

53K+ Views

In this article, we will show you how to convert date and time with different timezones in Python. Using astimezone() function Using datetime.now() function The easiest way in Python date and time to handle timezones is to use the pytz module. This library allows accurate and cross−platform timezone calculations. pytz brings the Olson tz database into Python. It also solves the issue of ambiguous times at the end of daylight saving time, which you can read more about in the Python Library Reference (datetime.tzinfo) Before you use it you'll need to install it using − pip install pytz ... Read More

How to compare time in different time zones in Python?

Vikram Chiluka
Updated on 28-Sep-2023 01:37:36

6K+ Views

In this article, we will show you how to compare time to different timezones in Python using the below methods. Comparing the given Timezone with the local TimeZone Comparing the Current Datetime of Two Timezones Comparing Two Times with different Timezone Method 1: Comparing the given Timezone with the local TimeZone Algorithm (Steps) Following are the Algorithm/steps to be followed to perform the desired task – Use the import keyword, to import the datetime, pytz modules. Use the timezone() function (gets the time zone of a specific location) of the pytz module, to get the timezone ... Read More

How to do date validation in Python?

Vikram Chiluka
Updated on 27-Aug-2023 03:29:17

33K+ Views

In this article, we will show you how to do date validation in Python. Now we see 2 methods to accomplish this task− Using datetime.strptime() function Using dateutil.parser.parse() function Method 1: Using datetime.strptime() function Algorithm (Steps) Following are the Algorithm/steps to be followed to perform the desired task − Use the import keyword, to import the datetime (To work with dates and times) module. Enter the date as a string and create a variable to store it. Enter the date format as a string and create another variable to store it. Use the try−except blocks for handling the ... Read More

How to compare date strings in Python?

Rajendra Dharmkar
Updated on 13-Jun-2020 06:01:28

1K+ Views

Python date implementations support all the comparision operators. So, if you are using the datetime module to create and handle date objects, you can simply use the , =, etc. operators on the dates. This makes it very easy to compare and check dates for validations, etc.Examplefrom datetime import datetime from datetime import timedelta today = datetime.today() yesterday = today - timedelta(days=1) print(today < yesterday) print(today > yesterday) print(today == yesterday)OutputThis will give the output −False True False

How to insert date object in MySQL using Python?

SaiKrishna Tavva
Updated on 05-Mar-2025 17:40:18

18K+ Views

When working with databases, especially MySQL, handling dates correctly is crucial. Python's datetime module provides powerful tools for managing dates and times. To insert a date into a MySQL database, which has a column of DATE or DATETIME type. Following are several methods to achieve this. Using strftime() for Formatting Using isoformat() Method Passing datetime object directly to the connector Using 'strftime()' for Formatting The strftime() method allows you to format a datetime object into a string according to a specific format. The '%Y', '%m', '%d', ... Read More

How to store and retrieve a date into MySQL database using Python?

Rajendra Dharmkar
Updated on 28-Sep-2023 01:40:28

5K+ Views

To insert a date in a MySQL database, you need to have a column of Type date or datetime in your table. Once you have that, you'll need to convert your date in a string format before inserting it to your database. To do this, you can use the datetime module's strftime formatting function.Example from datetime import datetime now = datetime.now() id = 1 formatted_date = now.strftime('%Y-%m-%d %H:%M:%S') # Assuming you have a cursor named cursor you want to execute this query on: cursor.execute('insert into table(id, date_created) values(%s, %s)', (id, formatted_date))Running this will try to insert the tuple (id, date) ... Read More

How to store and retrieve date into Sqlite3 database using Python?

Rajendra Dharmkar
Updated on 12-Jun-2020 14:00:29

2K+ Views

You can very easily store and retrieve date into Sqlite3 database using the sqlite3 module. When inserting the date in the database, pass the date directly and Python handles it automatically.Exampleimport sqlite3 import datetime conn = sqlite3.connect(":memory:", detect_types=sqlite3.PARSE_DECLTYPES) conn.execute('''CREATE TABLE TEST (ID TEXT PRIMARY KEY NOT NULL, DATE DATE)''') # Save changes conn.commit() # Insert the object directly conn.execute("INSERT INTO TEST (ID, DATE) VALUES (?, ?)", ('My date', datetime.date(2018, 1, 4))) conn.commit() print("Record inserted")OutputThis will give the output −Record insertedNow when you will fetch the values from the database, you will get the date already parsed to the datetime object.Exampleimport ... Read More

What are Python modules for date manipulation?

Rajendra Dharmkar
Updated on 19-Feb-2020 09:46:01

260 Views

There are many modules available in both the standard library and the PiPy repository for date manipulation. The most popular among these libraries are the following(in no particular order) −datetime (Standard library) − The datetime module supplies classes for manipulating dates and times in both simple and complex ways. While date and time arithmetic is supported, the focus of the implementation is on efficient attribute extraction for output formatting and manipulation.time(Standard library) − This module provides various time-related functions. Although this module is always available, not all functions are available on all platforms. Most of the functions defined in this ... Read More

How do I display the date, like "Aug 5th", using Python's strftime?

Rajendra Dharmkar
Updated on 12-Jun-2020 13:42:44

2K+ Views

It is not possible to get a suffix like st, nd, rd and th using the strftime function. The strftime function doesn't have a directive that supports this formatting. You can create your own function to figure out the suffix and add it to the formatting string you provide.Examplefrom datetime import datetime now = datetime.now() def suffix(day):   suffix = ""   if 4

Advertisements