RE: [SQL] indexing a datetime by date - Mailing list pgsql-sql

From Jackson, DeJuan
Subject RE: [SQL] indexing a datetime by date
Date
Msg-id D05EF808F2DFD211AE4A00105AA1B5D2037A23@cpsmail
Whole thread Raw
List 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


pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: [SQL] indexing a datetime by date
Next
From: Andrew Merrill
Date:
Subject: Re: [SQL] indexing a datetime by date