Javatpoint Logo
Javatpoint Logo

How to insert current_timestamp into Postgres via Python?

PostgreSQL supports two types of data to process timestamps: time stamp and timestamptz. Timestamp data type allows us to create a timestamp that is not based on the timezone. Likewise, timestamptz can help us create a timestamp with the timezone. It is possible to store dates and times using the datatype timestamp. It does not, however, include time zone information. This means that if you change the timezone of your database server, the values for timestamps stored in the database won't immediately update, and in these circumstances, the datatype timestamptz is used.

Example:

The code below illustrates the datatypes. psycopg2.connect() technique is utilized to connect with the database. A cursor can be created by connection.cursor() method. connection.cursor() method. execute() method executes the SQL commands specified. A table called timestamp_data is made. A time stamp formatted in a string is added to the table that is created. The values are then retrieved from the table. The table is where we see the column timestamp_timezone as well as the timezone.

Output:

How to insert current_timestamp into Postgres via Python





Youtube For Videos Join Our Youtube Channel: Join Now

Feedback


Help Others, Please Share

facebook twitter pinterest

Learn Latest Tutorials


Preparation


Trending Technologies


B.Tech / MCA