postgresql get date from datetime 1

postgresql get date from datetime

SELECT DATE(column_name) FROM table_name;

Here is what the above code is Doing:
1. We’re selecting the column_name column from the table_name table.
2. We’re using the DATE() function to extract the date from the column_name column.

Similar Posts