pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedPostgres 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