On 4/30/19 12:11 PM, Andrew Gierth wrote:
"Adrian" == Adrian Klaver writes:
>> yeesh. that's a very long-winded way to write current_date + 7
Adrian> Yeah, I was just working of the OP's original DEFAULT:
Adrian> site_mode_date timestamp NOT NULL DEFAULT date_trunc('day',
Adrian> LOC
> "Adrian" == Adrian Klaver writes:
>> yeesh. that's a very long-winded way to write current_date + 7
Adrian> Yeah, I was just working of the OP's original DEFAULT:
Adrian> site_mode_date timestamp NOT NULL DEFAULT date_trunc('day',
Adrian> LOCALTIMESTAMP)+7,
Right, but since all these
On 4/30/19 8:00 AM, Andrew Gierth wrote:
"Adrian" == Adrian Klaver writes:
Adrian> Or cast to a date:
Adrian> test=> select date_trunc('day', localtimestamp)::date + 7;
yeesh. that's a very long-winded way to write current_date + 7
Yeah, I was just working of the OP's original DEFAULT
On 30/04/2019 16:00, Andrew Gierth wrote:
"Adrian" == Adrian Klaver writes:
Adrian> Or cast to a date:
Adrian> test=> select date_trunc('day', localtimestamp)::date + 7;
yeesh. that's a very long-winded way to write current_date + 7
Well, current_date is different: current_date returns
> "Adrian" == Adrian Klaver writes:
Adrian> Or cast to a date:
Adrian> test=> select date_trunc('day', localtimestamp)::date + 7;
yeesh. that's a very long-winded way to write current_date + 7
--
Andrew (irc:RhodiumToad)
On 4/30/19 2:24 AM, Thomas Kellerer wrote:
Daulat Ram schrieb am 30.04.2019 um 05:46:
We are getting an ERROR: “operator does not exist: timestamp without
time zone + integer “ while creating table in postgres. The same
script is working fine in Oracle, I know there are some changes in
Daulat Ram schrieb am 30.04.2019 um 05:46:
> We are getting an ERROR: “operator does not exist: timestamp without
> time zone + integer “ while creating table in postgres. The same
> script is working fine in Oracle, I know there are some changes in
> postgres but I am unable to ident
Hi team,
We are getting an ERROR: "operator does not exist: timestamp without time zone
+ integer " while creating table in postgres. The same script is working fine
in Oracle, I know there are some changes in postgres but I am unable to
identify . Please suggest how we can
