79354806

Date: 2025-01-14 11:11:28
Score: 1
Natty:
Report link

Excel serial dates are the number of days since January 1, 1900.

Excel's day 1 corresponds to 1900-01-01. So, add the Excel serial number (45669 in this case) as days to this base date using DATE_ADD.

The Query will look like this:

SELECT DATE_ADD('1900-01-01', INTERVAL 45669 DAY) AS normal_date;
Reasons:
  • Low length (0.5):
  • Has code block (-0.5):
  • Low reputation (1):
Posted by: Gabriel MGFC-DEV