[SQL] join two tables with sharing some columns between two

Hi, I have two tables like these: (this is an example, the actual tables have diffferent fields and meanings) TABLE1 id person_name date_arrival date_departure TABLE2 id car_description date_arrival date_departure I'd like to make a query to have such resulting table RESULTING_TABLE id person_

[SQL] datestyle on windows environment: how to set?

version of pgsql and perl. Hereafter is an extract of my postgresql.conf file. Thanks and best regards, Filippo # - Locale and Formatting - datestyle = 'ISO, European' #timezone = unknown # actually, defaults to TZ # environment