Обсуждение: RE: [SQL] indexing a datetime by date

Поиск
Список
Период
Сортировка

RE: [SQL] indexing a datetime by date

От
"Jackson, DeJuan"
Дата:
> 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