Understanding postgresql

A 10 minutes postgresql chrash course, with just enout make your own Custom Data Extracts

Methods 

1

SOME_METHOD(PARAMETERS)

🔗 Postgresql documentation

The following is an explnation and some snippets you can copy and paste.

Extracting the year with 4 digits. 

1

TO_CHAR(extract_forecasting.movement_date, 'IYYY')

This example us using the the ISO 8601 week-numbering for formating the year with 4.

Understanding Postgresql methods and documentation

If you find postgres documentation intimidating and magic you can read this little introduction to postgresql.