summary
Stores date and time data.
The valid range of the value is from 0:00:0:0 on January 1, 1 year to 23:59:59 on December 31, 9999. If the valid range is exceeded, the value is reset to 0:00:0:0 on January 0, 0 year.
0 year, 0 month, 0 day, 0 hour, 0 minute, 0 second represents an unset state as a date and time.
minimum value
Unset value 0 year 0 month 0 day 0 hour 0 minute 0 second
Valid minimum value 1 year, 1 day, 0:0:0
greatest value
Valid maximum value 9999-12-31 23:59:59
type conversion rule
| target of conversion | terms | Value after conversion | remarks |
|---|---|---|---|
| character string data | nashi (Pyrus pyrifolia, esp. var. culta) | Y/M/D h:m:s | Date and time as a string in "Y/M/D h:m:s" format Conversion. Each value is zero suppressed. |
| numeric data | nashi (Pyrus pyrifolia, esp. var. culta) | 0 | |
| dictionary (Associative array) |
- | ||
| video data | - | ||
| binary data | - |