Date: Sat, 7 Oct 2023 16:28:23 +0200
From: Bzzzz <lazyvirus@gmx.com>
To: pgsql-novice@lists.postgresql.org
Subject: Re: Is `DATE` a function?
Message-ID: <20231007162823.6c5929c9@msi.defcon1.lan>
In-Reply-To: 
 <CAK3STzGm-8_5yvyWm_SJALo1Wb1i3cMJrBj8=WPmVyxHdhmYrg@mail.gmail.com>
References: 
 <CAK3STzGm-8_5yvyWm_SJALo1Wb1i3cMJrBj8=WPmVyxHdhmYrg@mail.gmail.com>
Organization: Anyone, anywhere but in banana demokratik republik of france
 or UERSS.
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: quoted-printable
UI-OutboundReport: notjunk:1;M01:P0:49cDKQjnpZM=;0ZvsUtMksWvEev7yzsSBAMXa4x+
 Zn3q8vpgx4FhmgQ77rSDwog/eRMexo1k8RJJEYD8CZHOtFZAc5ZOxCS8wUAkSL1dbn/lStxgY
 gixBlDMurWZngxI9yTGlAtsRjHK2aB1DtzEL3UOvujeVciWxeq8f6yu8aKKyGAGkPlBtEpc6Z
 QmFF9E/A1R/7de1jjajQdQZHh5zSgJK0B85E8VxGHrXmrQcFrxs4uKLzl7qzX9u++aYun/QFB
 MyzQquKB431waDHC10+eHajbuWxO0v3N+gofWhNM9/tnIavie9empwNX12cLrrCWEfAR2gPhy
 CgWJIyhiYwTBSTGZS+sSeSgjvV/TiRxykXmxNa/ejxF6aLEXMg9Ib3hu0C3b6f90Dft2LzEmG
 iWjBnmUHKPrchiP1D01sru9aZ+/0p9waL1Sin3KyupoX06avQ8tziq0L4IbVQrvC6Rqb2BNZl
 /oqyfc25lzMUWtaJPnhel95281gxe/6reodz4sQjvKFsJGfoglJKl4ZXN1FZA78UiUTMarkW2
 GewxmUOEbvg/cOJhw9SxYyoBvihrOiZ9gz50I2FmzDafbm1S5mVBbojq6o4Z7KuFgTAnEWCva
 ncNDmH/vO4j1Xa2ifnjvU5rltUer9mq06DeMCe7JY9cL/ytWT70qS2AdwRlWdLddilEJDudhA
 MTShKJyVQy8ixmSfdjZSYW+zmgqLQVzoSHhFSlJthXqOjYi461oCnHrSgCDVS7+SzJhyz3GxP
 8/j8oF8ysiFsUDj+V31SeINZRjiASY1OKnfNknl9qSq3Rmh9mbqYfJCkxi9w7UDWORveRGRT9
 cwSiZEQF8cpkf4mvARUliU6T/bJFTue6GZ7TrwfvNcbEozys6OZFMifPSBgr0Ip8xiZpucPZ3
 etlYY67b7zEHfm/RlkizHcKVcbe0whxoNmyvfbQrXA2mpJzYxOOV1exLRJ9Db2jzKZF6ra131
 6smU4g==
Archived-At: 
 <https://www.postgresql.org/message-id/20231007162823.6c5929c9%40msi.defcon1.lan>
Precedence: bulk

On Sat, 7 Oct 2023 21:01:59 +0800
jinser <aimer@purejs.icu> wrote:

Hi,

> Hello, Friends,
>
> Use it like a normal function:
>
> playground=3D# SELECT DATE();
> ERROR:  function date() does not exist
> LINE 1: SELECT DATE();
>                ^
> HINT:  No function matches the given name and argument types. You
> might need to add explicit type casts.
>
> playground=3D# SELECT DATE('2022-01-13');
>     date
> ------------
>  2022-01-13
> (1 row)
>
> Another reason I think this is a function is that other types don't
> seem to have the same behavior:
>
> playground=3D# SELECT integer('123');
> ERROR:  syntax error at or near "("
> LINE 1: SELECT integer('123');
>                       ^
>
> The Table 9.33. Date/Time Functions in the documentation
> (https://www.postgresql.org/docs/16/functions-datetime.html#FUNCTIONS-DA=
TETIME-TABLE)
> doesn't mention this...
> If I missed it, where should I find the description? Or maybe it
> actually should be in this table?

Is is both a function and an operator, but the function has an arity of
one (text, representing a date, timestamp, etc), hence the error message
you've got.
If you just want to get today's date, use : SELECT current_date;
or if you want to twist your mind : SELECT date(now());

Jean-Yves