Re: Inserting the current date

From: Thomas Lockhart <lockhart(at)fourpalms(dot)org>
To: john <servobit(at)www2(dot)us(dot)postgresql(dot)org>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Inserting the current date
Date: 2001-12-10 16:48:37
Message-ID: 3C14E765.872BB7A@fourpalms.org
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'

(note single quotes; they are treated like values, not a keyword).

- Thomas

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tim Nelson 2001-12-10 17:07:26 ecpg - select * into structure problem
Previous Message Troy.Campano 2001-12-10 16:46:11 Re: Any comments on any of the recent crop of books?