RE: [SQL] indexing a datetime by date

From: "Jackson, DeJuan" <djackson(at)cpsgroup(dot)com>
To: Herouth Maoz <herouth(at)oumail(dot)openu(dot)ac(dot)il>, pgsql-sql(at)postgreSQL(dot)org
Subject: RE: [SQL] indexing a datetime by date
Date: 1999-03-30 17:21:12
Message-ID: D05EF808F2DFD211AE4A00105AA1B5D2037A23@cpsmail
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


> How about using the ANSI standard CURRENT_DATE instead of either? It's
> already of type date. Or is it considered a function call?
>
> Herouth
Not sure how PostgreSQL implements that.
It would appear to be implemented just as now().
Try:
select CURRENT_DATE::TIME, now()::TIME;

-DEJ

Browse pgsql-sql by date

  From Date Subject
Next Message Andrew Merrill 1999-03-30 17:25:39 Re: [SQL] indexing a datetime by date
Previous Message Tom Lane 1999-03-30 16:31:35 Re: [SQL] indexing a datetime by date