Linto davis Linto davis - 8 months ago 45
SQL Question

How to write a postgresql query for getting only the date part of timestamp field, from a table

How to write a postgresql query for getting only the date part of timestamp field, from a table

Answer
select DATE(my_field) from my_table;