Validate the datetime value: Difference between revisions

Validate the datetime value (edit)

941 bytes added , 12:29

14,974

edits

@@ Line 24: / Line 24: @@
 * Expected format: YYYY-MM-DD
+Schema SQL:
+<pre>
+CREATE TABLE sample_date_validation (
+  date_column VARCHAR(20),
+  is_abnormal BOOLEAN,
+  comments    VARCHAR(100)
+);
+INSERT INTO sample_date_validation (date_column, is_abnormal, comments) VALUES
+  ('2024-01-15',   FALSE, 'Valid date'),
+  ('2023-12-31',   FALSE, 'Valid date'),
+  ('2000-02-29',   FALSE, 'Valid leap year date'),
+  ('1999-01-01',   FALSE, 'Valid date'),
+  ('2024-13-01',   TRUE,  'Invalid month (13)'),
+  ('2023-00-10',   TRUE,  'Invalid month (00)'),
+  ('2023-06-31',   TRUE,  'Invalid day (June has 30 days)'),
+  ('2023-02-30',   TRUE,  'Invalid day (February)'),
+  ('1900-00-00',   TRUE,  'Zero-like date'),
+  ('0000-00-00',   TRUE,  'All zeros'),
+  ('abcd-ef-gh',   TRUE,  'Non-numeric string'),
+  ('20240115',     TRUE,  'Missing dashes'),
+  ('15-01-2024',   TRUE,  'Wrong format DD-MM-YYYY'),
+  ('2024/01/15',   TRUE,  'Wrong separator'),
+  (NULL,           TRUE,  'NULL value');
+</pre>
+Query SQL:
 <pre>
 SELECT CAST(date_column AS DATE) AS date_column