MIME-Version: 1.0
References: 
 <CAK3STzGm-8_5yvyWm_SJALo1Wb1i3cMJrBj8=WPmVyxHdhmYrg@mail.gmail.com>
In-Reply-To: 
 <CAK3STzGm-8_5yvyWm_SJALo1Wb1i3cMJrBj8=WPmVyxHdhmYrg@mail.gmail.com>
From: Cory Albrecht <cory@albrecht.name>
Date: Mon, 16 Oct 2023 11:42:49 -0400
Message-ID: 
 <CAMW5rYLbjRn_WL8kGQDbt6CtivFnFNJyavZRAvXidgEEHDt-YA@mail.gmail.com>
Subject: Re: Is `DATE` a function?
To: jinser <aimer@purejs.icu>
Cc: pgsql-novice@lists.postgresql.org
Content-Type: multipart/alternative; boundary="000000000000cead640607d7428f"
Archived-At: 
 <https://www.postgresql.org/message-id/CAMW5rYLbjRn_WL8kGQDbt6CtivFnFNJyavZRAvXidgEEHDt-YA%40mail.gmail.com>
Precedence: bulk

--000000000000cead640607d7428f
Content-Type: text/plain; charset="UTF-8"

Rather than `SELECT DATE();` you likely want `SELECT NOW();`

On Sat, Oct 7, 2023, 09:20 jinser <aimer@purejs.icu> wrote:

> Hello, Friends,
>
> Use it like a normal function:
>
> playground=# 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=# 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=# 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-DATETIME-TABLE
> )
> doesn't mention this...
> If I missed it, where should I find the description? Or maybe it
> actually should be in this table?
>
> Thanks in advance.
>
>
>

--000000000000cead640607d7428f
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"auto">Rather than `SELECT DATE();` you likely want `SELECT NOW(=
);`</div><br><div class=3D"gmail_quote"><div dir=3D"ltr" class=3D"gmail_att=
r">On Sat, Oct 7, 2023, 09:20 jinser &lt;aimer@purejs.icu&gt; wrote:<br></d=
iv><blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left=
:1px #ccc solid;padding-left:1ex">Hello, Friends,<br>
<br>
Use it like a normal function:<br>
<br>
playground=3D# SELECT DATE();<br>
ERROR:=C2=A0 function date() does not exist<br>
LINE 1: SELECT DATE();<br>
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0^<br>
HINT:=C2=A0 No function matches the given name and argument types. You<br>
might need to add explicit type casts.<br>
<br>
playground=3D# SELECT DATE(&#39;2022-01-13&#39;);<br>
=C2=A0 =C2=A0 date<br>
------------<br>
=C2=A02022-01-13<br>
(1 row)<br>
<br>
Another reason I think this is a function is that other types don&#39;t<br>
seem to have the same behavior:<br>
<br>
playground=3D# SELECT integer(&#39;123&#39;);<br>
ERROR:=C2=A0 syntax error at or near &quot;(&quot;<br>
LINE 1: SELECT integer(&#39;123&#39;);<br>
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=
=A0 ^<br>
<br>
The Table 9.33. Date/Time Functions in the documentation<br>
(<a href=3D"https://www.postgresql.org/docs/16/functions-datetime.html#FUNC=
TIONS-DATETIME-TABLE" rel=3D"noreferrer noreferrer" target=3D"_blank">https=
://www.postgresql.org/docs/16/functions-datetime.html#FUNCTIONS-DATETIME-TA=
BLE</a>)<br>
doesn&#39;t mention this...<br>
If I missed it, where should I find the description? Or maybe it<br>
actually should be in this table?<br>
<br>
Thanks in advance.<br>
<br>
<br>
</blockquote></div>

--000000000000cead640607d7428f--