Re: Timestamp conversion Error in dynamic sql script

From: Greg Sabino Mullane <htamfids(at)gmail(dot)com>
To: Erik Wienhold <ewie(at)ewie(dot)name>
Cc: sud <suds1434(at)gmail(dot)com>, pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Timestamp conversion Error in dynamic sql script
Date: 2024-04-02 14:16:04
Message-ID: CAKAnmmJXnjoEJRxRd7az0pSZX6UDMeNG=5ZUgZmKgha2VVdmUw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

>
> 1. Declare start_date as DATE when you want to add days with date + int
> 2. Keep TIMESTAMP and use start_date + make_interval(days => i)
>

Also

0. Use TIMESTAMPTZ not TIMESTAMP

Cheers,
Greg

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2024-04-02 14:43:35 Re: Getting wrong datetime in database using insert into table query.
Previous Message Erik Wienhold 2024-04-02 12:01:44 Re: Timestamp conversion Error in dynamic sql script