I am having problems converting dates in SQLite to dates using the correct YYYY-MM-DD format. The field ([datetime]) value is 40705.3883778125. If I use Select date(datetime) as oDate from tblMonitor, oDate = -4601-05-06. why does it not say 2011-05-06?
8/22/2022 - Mon
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!