Thread: RE: [SQL] indexing a datetime by date

RE: [SQL] indexing a datetime by date

From
"Jackson, DeJuan"
Date:
> 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