Validate the datetime value: Difference between revisions
Jump to navigation
Jump to search
→Verify the value is not 1900-01-20 xx:xx:xx
| Line 17: | Line 17: | ||
</pre> | </pre> | ||
=== Verify the value is not 1900-01- | === Verify the value is not 1900-01-xx xx:xx:xx === | ||
Schema of column value | Schema of column value | ||
* Type: VARCHAR | * Type: VARCHAR | ||
* Default value: allow be NULL | * Default value: allow be NULL | ||
Abnormal values e.g. {{kbd | key=1900-01-08 00:00:00}} because the Excel datetime issue<ref>[https://support.microsoft.com/en-us/office/date-systems-in-excel-e7fe7167-48a9-4b96-bb53-5612a800b487 Date systems in Excel - Microsoft Support]</ref> | |||
<pre> | <pre> | ||