Answers for "year from timestamp postgresql"

postgresql get year

select extract(year from your_column) from your_table;

Posted by: Guest on May-26-2020

postgresql get date from datetime

SELECT DATE(column_name) FROM table_name;

Posted by: Guest on December-07-2020

Code answers related to "year from timestamp postgresql"