Re: problem with date/time constants

From: David Stanaway <david(at)netventures(dot)com(dot)au>
To: <pgsql-sql(at)postgresql(dot)org>
Cc: quals(at)bigfoot(dot)com
Subject: Re: problem with date/time constants
Date: 2001-07-03 13:03:42
Message-ID: E15HQI9-0004pM-00@runt.in.netventures.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)NetVentures(dot)com(dot)au Office +612 9357 1699
========================'---------------------------------------------

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Alex Pilosov 2001-07-03 13:08:48 Re: problem with date/time constants
Previous Message datactrl 2001-07-03 12:44:44 problem with date/time constants