Answers for "extract date from datetime postgresql"

SQL
1

postgresql get date from datetime

SELECT DATE(column_name) FROM table_name;
Posted by: Guest on December-07-2020
0

postgres extract date from timestamp

SELECT DATE(SUBSTRING('2018-07-25 10:30:30' FROM 1 FOR 10));
Posted by: Guest on February-24-2021
0

postgres extract date from timestamp

SELECT DATE(column_name) FROM table_name;
Posted by: Guest on February-24-2021
0

postgres extract date from timestamp

SELECT '2018-07-25 10:30:30'::TIMESTAMP::DATE;
Posted by: Guest on February-24-2021

Code answers related to "extract date from datetime postgresql"

Code answers related to "SQL"

Browse Popular Code Answers by Language