> On Jan 6, 2017, at 12:16 PM, Ed Lipson <edlipso...@gmail.com> wrote: > > The Updated column is properly reflected as a float, as that is the > internal Excel format. What formatting functions can I use to get it to > appear as a date time in SQL output, as it appears in Excel? I have tried > strftime and date but I don't get any meaningful data.
This doesn’t seem like a question related to SQLite; you’ll need to find out the definition of Excel’s internal date/time format. Most numeric time formats have much larger numbers since they count in seconds, but the values around 42,000 that you showed would be consistent with a number of days since 1/1/1900. You can probably use one of the standard library functions to convert that into a time_t and print it. —Jens _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users