How to write a postgresql query for getting only the date part of timestamp field, from a table November 23, 2023 by Tarik select DATE(my_field) from my_table;