umidjons · July 5, 2013 11:08 · zinnatik24 · Jan 9, 2023
diff --git a/conv_5num_to_date.sql b/conv_5num_to_date.sql
 SELECT 
  iar_d AS date_5_num, /* numbers like: 40479, 40298, 39038, 41075 */
  DATE('1899-12-30') + INTERVAL iar_d DAY AS normal_date /* converted dates */
 FROM registry_private_clinics
 WHERE iar_d REGEXP '^[0-9]{5}$' /* only rows with NNNNN format, where N is [0-9] */
	SELECT
	iar_d AS date_5_num, /* numbers like: 40479, 40298, 39038, 41075 */
	DATE('1899-12-30') + INTERVAL iar_d DAY AS normal_date /* converted dates */
	FROM registry_private_clinics
	WHERE iar_d REGEXP '^[0-9]{5}$' /* only rows with NNNNN format, where N is [0-9] */