( Format Dates ) The Ultimate Guide to PostgreSQL Date By Examples

PHOTO EMBED

Fri Apr 30 2021 16:41:42 GMT+0000 (Coordinated Universal Time)

Saved by @mvieira

            

                
            

         
SELECT TO_CHAR(NOW() :: DATE, 'dd/mm/yyyy');
Code language: SQL (Structured Query Language) (sql)
content_copyCOPY

https://www.postgresqltutorial.com/postgresql-date/