Mustafa Abusalah Blog

The default postgres date format is yyyy-mm-dd in case you want to insert date in the format dd/mm/yyyy you need to set the datestyle at the beginning of your insert or update query as the below: set DateStyle = 'ISO, DMY' ;