Re: [SQL] Postgres Date/Time Special Constants

since they are "special", not "global", you need to use ''
and ::datetime
so, try:
select 'now'::datetime;
select 'infinity'::datetime + '1day'::timespan;
select 'current'::datetime + 1;

On Sat, 4 Dec 1999, Alexey V. Meledin wrote:

> Hi!
>
> Where can I see SUBJ?
> I try:
> select current - nothing
> select infinity - nothing
> epoch, now, today and etc.
>
> Works:
> select current_timestamp,
> current_date,
> current_time,
> now()
>
> Are special constants are not implemented yet?
>
> Regards, Alexey V. Meledin
> InterForge Developers Group, Saint-Petersburg
> look_to: <www.etcompany.ru><www.businessweb.ru>
> <www.inplan.spb.ru><www.pia.ru>>>>>>>>>>>>>>>>>
> mail_to: <avm(at)webclub(dot)ru><nick_as: <cureman>>>>
>
>
>
> ************
>