public inbox for [email protected]
help / color / mirror / Atom feedFrom: Muhammad Ikram <[email protected]>
To: Ray O'Donnell <[email protected]>
Cc: Rossana Ocampos <[email protected]>
Cc: [email protected]
Subject: Re: CURRENTE_DATE
Date: Thu, 24 Oct 2024 18:01:09 +0500
Message-ID: <CAJQ7xG5bxJV0+J-K1Sjxb6bA7j+Vi7smmoww7Z_7ThTgsmmvDA@mail.gmail.com> (raw)
In-Reply-To: <01020192b98778c0-78365d74-1341-45c8-b0de-cc6b962afcf9-000000@eu-west-1.amazonses.com>
References: <[email protected]>
<01020192b98778c0-78365d74-1341-45c8-b0de-cc6b962afcf9-000000@eu-west-1.amazonses.com>
Hi,
I am just thinking, when DEFAULT CURRENT_DATE is being used in table
definition then why the function is again being used in INSERT statement
why not use
default. Here is sample
edb=# create table date_test (id int, hiredate date default current_date);
CREATE TABLE
edb=# insert into date_test values (1, *default*);
INSERT 0 1
edb=# select * from date_test;
id | hiredate
----+--------------------
1 | 24-OCT-24 00:00:00
(1 row)
Regards,
Ikram
On Wed, Oct 23, 2024 at 6:18 PM Ray O'Donnell <[email protected]> wrote:
> On 22/10/2024 12:31, Rossana Ocampos wrote:
>
> *Hello ,*
>
> I am new with PostgreSQL and I have a bug. I have created a function that
> has an input variable of type date , in case it does not receive value , it
> has to assume by default the current date.
>
> I have defined it as follows variable DATE DEFAULT CURRENT_DATE, but I
> get the following error.
>
>
>
> *El error *
>
> ERROR: invalid input syntax for type date: “CURRENT_DATE” LINE 1:
> ...extsupplydate ('1085018'::bigint, '5278'::bigint, 'CURRENT_D... ^ ERROR:
> invalid input syntax for type date: “CURRENT_DATE” SQL status: 22007
> Characters: 78
>
>
> I think you just need to leave off the quotes, as current_date is a
> function:
>
> insert into .... values ( ... , current_date, ....);
>
> Also, you don't need to quote the bigint values.
>
>
> HTH,
>
> Ray.
>
>
>
>
> Please could you help me, thank you very much.
>
> Rossana
>
>
>
> --
> Raymond O'Donnell // Galway // [email protected]
>
>
view thread (5+ 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], [email protected]
Subject: Re: CURRENTE_DATE
In-Reply-To: <CAJQ7xG5bxJV0+J-K1Sjxb6bA7j+Vi7smmoww7Z_7ThTgsmmvDA@mail.gmail.com>
* 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