Re: [SQL] Postgres Date/Time Special Constants - Mailing list pgsql-sql

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@webclub.ru><nick_as: <cureman>>>>
> 
> 
> 
> ************
>