Issue with timestamp without time zone datatype with default value as now()/localtimestamp

From: Deepika S Gowda <deepika(dot)gs(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org, pgsql-general General <pgsql-general(at)postgresql(dot)org>
Subject: Issue with timestamp without time zone datatype with default value as now()/localtimestamp
Date: 2020-07-10 14:03:19
Message-ID: CADaTEeShceXK9CFifn3OzYUJQVfGqv3ab4d3fNkDpYvcUp_n3Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

On postgres 11.7 Master/Slave node, there is column named "createddate"
with datatype "timestamp without time zone" with default value as "now()";

Column Name | Date Type | Default value
createddate |timestamp without time zone|Now()

Issue: From the java application , data is getting loaded into this table
where we expect column value should be today's date with timestamp(
"2020-07-10 10:56:43.21"). But, out of 3K records, 100 records are loaded
as "2019-07-10 10:56:43.21" (change in Year).

What could be the issue? we tried changing the default value to
"localtimestamp".

Kindly help on this request

Regardss,
Deepika

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2020-07-10 14:09:00 Re: Issue with timestamp without time zone datatype with default value as now()/localtimestamp
Previous Message Adrian Klaver 2020-07-10 13:53:53 Re: Postgresql-12 taking more time to execute the query