public inbox for [email protected]  

help / color / mirror / Atom feed

From: Adrian Klaver <[email protected]>
To: Saksham Joshi <[email protected]>
To: [email protected]
Subject: Re: Getting wrong datetime in database using insert into table query.
Date: Tue, 2 Apr 2024 07:43:35 -0700
Message-ID: <[email protected]> (raw)
In-Reply-To: <CAPRm4pNrYGE4mbpGKUHJOD5vrWKP-ffK680Nmd-_0qqsWoL36A@mail.gmail.com>
References: <CAPRm4pNrYGE4mbpGKUHJOD5vrWKP-ffK680Nmd-_0qqsWoL36A@mail.gmail.com>

On 4/2/24 01:58, Saksham Joshi wrote:
> OS: Windows 10
> Psycopg version: 2.9.9
> Python version: 3.11.6
> PostgreSQL version: 11
> pip version : 24.0
> 1: what you did
> We are using 'psycopg2-binary' library to connect to my postgresql 
> hosted on Azure.We have created a table named 'apilog' to store our api 
> logs using 'Insert Into table' query.We have specifically added two 
> columns named create_date and update_date with 'timestamp with time 
> zone' property enabled.I only update create_date for each log locally 
> using python and i expected update_date column to automatically update 
> the datetime when the transaction is committed at the end in python.
> 2: what you expected to happen
> I expected to see update_date column returning datetime values which are 
> similar to the time the transaction is committed in python however 
> instead the value seems to returning datetime which is more closer to 
> the time db connection is established.
> 3: what happened instead
> The datetime value in update_date is coming earlier than the create_date 
> value of even the very first log which is creating discrepancy and 
> making it difficult to track the exact time logs are committed into 
> database.
> 
> For example:
> This query INSERT INTO api_log(log_detail,create_date)
> VALUES('example log 1', datetime.datetime.utcnow'),('example log 2', 
> datetime.datetime.utcnow')
> Should ideally return update_date which is older than 'example log 2' 
> create_date but it is returning a datetime which is even earlier than 
> 'example log 1' create_date.


Read:

https://www.postgresql.org/docs/current/functions-datetime.html#FUNCTIONS-DATETIME-CURRENT

-- 
Adrian Klaver
[email protected]

view thread (2+ messages)

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: Getting wrong datetime in database using insert into table query.
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox