Re: Inserting the current date

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: lockhart(at)fourpalms(dot)org
Cc: john <servobit(at)www2(dot)us(dot)postgresql(dot)org>, pgsql-general(at)postgresql(dot)org
Subject: Re: Inserting the current date
Date: 2001-12-12 03:34:54
Message-ID: 200112120334.fBC3YsG24352@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> > Is there an equivalent to Oracle's "sysdate" keyword?
>
> 'now'
>
> or
>
> date 'now'

Isn't CURRENT_TIMESTAMP what we should be recommending? Just checking.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Robert B. Easter 2001-12-12 06:07:51 Re: What is the practical limitation of no multi-threading?
Previous Message Bruce Momjian 2001-12-12 02:55:14 Re: What is the practical limitation of no multi-threading?