Hi, we seem to have a problem entering dates pre 1970. We use a field of type ‘datetime’ in Servoy.
We use PostgreSQL as backend, and
PostgreSQL time stamps (timestamp without time zone) should cope with 4713 BC to 874897 AD with a resolution of 1 microsecond.
Is this a limitation of Servoy, Java or something else going on?
Found this:
epoch 1970-01-01 00:00:00+00 (Unix system time zero)
. Don’t know if that means that this is the minimum date you can enter though…
Sorry, false alarm. I have got clarification on this one.
Servoy is fine, it is mySQL and the PHP website playing up.
My customer just put on some stock into their database from 1854 