pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Postgres Date/Time Special Constants
2+ messages / 2 participants
[nested] [flat]

* Postgres Date/Time Special Constants
@ 1999-12-04 20:25  Alexey V. Meledin <avm@webclub.ru>
  0 siblings, 1 reply; 2+ messages in thread

From: Alexey V. Meledin @ 1999-12-04 20:25 UTC (permalink / raw)
  To: pgsql-sql

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>>>>





^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: [SQL] Postgres Date/Time Special Constants
@ 1999-12-05 01:49  kaiq@realtyideas.com
  parent: Alexey V. Meledin <avm@webclub.ru>
  0 siblings, 0 replies; 2+ messages in thread

From: kaiq@realtyideas.com @ 1999-12-05 01:49 UTC (permalink / raw)
  To: Alexey V. Meledin <avm@webclub.ru>; +Cc: 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>>>>
> 
> 
> 
> ************
> 




^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~1999-12-05 01:49 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-12-04 20:25 Postgres Date/Time Special Constants Alexey V. Meledin <avm@webclub.ru>
1999-12-05 01:49 ` kaiq@realtyideas.com

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox