Re: Default for date field: today vs CURRENT_DATE [RESOLVED] - Mailing list pgsql-general

On Wed, 2 Jan 2019, Tom Lane wrote:

> 'today' is special as a date input string, so you can use it as a literal:
>
> regression=# select 'today'::date;
>    date
> ------------
> 2019-01-02
> (1 row)
>
> But it's not a SQL keyword, nor a function name, so you can't write it
> without quotes.

Tom,

   Now I understand. I tried it with quotes, too, but this was in the table
definition, not as a selection criterion. I did not pick up this difference
when reading about the date-time data types.

   Thanks very much for clarifying.

Best regards,

Rich