OPAL-2983: JDBC datasource for mysql/mariadb cannot store datetime values before 1970-1-1

[ymarcon]

Jira issue originally created by user @ymarcon:

In mysql/mariadb values of SQL Timestamp column must be greater than the epoch time.
Then for values in Opal of type datetime, this is a constraint (for birth dates for instance).

[ymarcon]

Comment created by @ymarcon:

DATETIME type should be used in place of TIMESTAMP:

https://dev.mysql.com/doc/refman/5.7/en/datetime.html

{quote}The DATETIME type is used for values that contain both date and time parts. MySQL retrieves and displays DATETIME values in 'YYYY-MM-DD HH:MM:SS' format. The supported range is '1000-01-01 00:00:00' to '9999-12-31 23:59:59'.

The TIMESTAMP data type is used for values that contain both date and time parts. TIMESTAMP has a range of '1970-01-01 00:00:01' UTC to '2038-01-19 03:14:07' UTC.{quote}

[ymarcon]

Comment created by @ymarcon:

Should be ok with postgresql:
https://www.postgresql.org/docs/9.1/static/datatype-datetime.html