Re: problem with date/time constants - Mailing list pgsql-sql

On Tuesday, July 3, 2001, at 10:44  PM, datactrl wrote:

> Hi,
> server:PostgreSQl 7.1
> why doesn't following statement work?
> "select now;"

Tried rtfm? :P
How about:

SELECT CURRENT_TIMESTAMP as now;

--
Best Regards
David Stanaway
========================.---------------------------------------------
Technology Manager  -  Australia's Premier Internet Broadcasters
david@NetVentures.com.au     Office +612 9357 1699
========================'---------------------------------------------