Validate the datetime value: Difference between revisions
Jump to navigation
Jump to search
m
→MySQL approach
m (→MySQL approach) |
|||
| Line 9: | Line 9: | ||
FROM `my_table` | FROM `my_table` | ||
WHERE DAY(`my_date_column`) IS NULL; | WHERE DAY(`my_date_column`) IS NULL; | ||
</pre> | </pre> | ||
| Line 45: | Line 44: | ||
STR_TO_DATE(`my_time_column`, '%Y-%m-%d %H:%i:%S') IS NULL; | STR_TO_DATE(`my_time_column`, '%Y-%m-%d %H:%i:%S') IS NULL; | ||
</pre> | |||
Verify the value not start with four number, which means year. {{exclaim}} Not recommended! | |||
<pre> | |||
SELECT `my_date_column` | |||
FROM `my_table` | |||
WHERE `my_date_column` NOT REGEXP '^[0-9]{4}'; | |||
</pre> | </pre> | ||