Linto davis Linto davis - 3 months ago 9
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;
Comments