How to convert postgres timestamp to date: yyyy-mm-dd

Поиск
Список
Период
Сортировка
От CaseT
Тема How to convert postgres timestamp to date: yyyy-mm-dd
Дата
Msg-id dd57bbe6-6b91-4505-a952-e634c2c08ef8@i29g2000prf.googlegroups.com
обсуждение исходный текст
Ответы Re: How to convert postgres timestamp to date: yyyy-mm-dd
Re: How to convert postgres timestamp to date: yyyy-mm-dd
Список pgsql-general
Hi All,

I'm a novice but learning quickly and I'm stumped on how to do this.

I need to convert postgres timestamp to date format yyyy-mm-dd in a
sql statement.
pt.created_date below is timestamp format

i.e ... WHERE pt.created_date >=  '2008-01-21'

Any help would be greatly appreciated.

Thanks, Case

В списке pgsql-general по дате отправления: