Validate the datetime value: Difference between revisions
Jump to navigation
Jump to search
m
→MySQL approach
m (→MySQL approach) |
|||
| Line 19: | Line 19: | ||
=== Verify the value is null === | === Verify the value is null === | ||
Verify the value of {{kbd | key=DAY()}}<ref>[https://dev.mysql.com/doc/refman/8.0/en/date-and-time-functions.html MySQL :: MySQL 8.0 Reference Manual :: 12.7 Date and Time Functions]</ref> is NULL | Verify the value of {{kbd | key=DAY()}}<ref>[https://dev.mysql.com/doc/refman/8.0/en/date-and-time-functions.html MySQL :: MySQL 8.0 Reference Manual :: 12.7 Date and Time Functions]</ref> is NULL | ||
Schema of column value | |||
* Type: datetime | |||
* Default value: allow be NULL | |||
<pre> | <pre> | ||
SELECT `my_date_column` | SELECT `my_date_column` | ||