79413691

Date: 2025-02-05 05:11:27
Score: 2.5
Natty:
Report link

Thanks to life888888 a minor change, the starting date is 0001 instead 0101.

select IT_NUMBER,IT_SUBJECT,
   DATE_ADD('0001-01-01', INTERVAL IT_REFDATE DAY) AS AddedOn, 
    IT_REFDATE ,
  DATE_ADD('0001-01-01', INTERVAL IT_ModifiedDate DAY) AS 
  ModifiedOn, IT_ModifiedDate 
from items ORDER BY IT_NUMBER DESC LIMIT 100

enter image description here

Thank you life8888888

Reasons:
  • Blacklisted phrase (0.5): Thank you
  • Blacklisted phrase (0.5): Thanks
  • Probably link only (1):
  • Has code block (-0.5):
  • Self-answer (0.5):
  • Low reputation (0.5):
Posted by: Moshe Yalovsky