Validate the datetime value: Difference between revisions
Jump to navigation
Jump to search
m
no edit summary
mNo edit summary |
|||
| Line 9: | Line 9: | ||
* Type: {{kbd | key=datetime}} | * Type: {{kbd | key=datetime}} | ||
* Default value: 0000-00-00 00:00:00 (NOT allow be NULL) | * Default value: 0000-00-00 00:00:00 (NOT allow be NULL)、"1999/12/31 上午 12:00:00" on Google sheet | ||
<pre> | <pre> | ||
| Line 23: | Line 23: | ||
* 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> | 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> | ||