Re: [sqlite] Date Formatting from Excel Float Date/Time Representation

select t0.key, "Issue Type", strftime('%Y-%m-%d %H:%M:%S', (Updated - (julianday('1970-01-01') - julianday('1899-12-30'))) + 2440587.5) Updated from JIRA_Stat_0_20170106124800 t0 inner join JIRA_Stat_1_20170106124800 t1 on t0.key = t1.key where "Last Comment" is not null order by assignee;

Re: [sqlite] Date Formatting from Excel Float Date/Time Representation

> On Jan 6, 2017, at 12:16 PM, Ed Lipson 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 >

[sqlite] Date Formatting from Excel Float Date/Time Representation

I'm trying to work with JIRA information. I export my JIRA records and load them into a SQLite3 database via a python script. The export is in Excel format. When I send the data back from SQLite3 to Excel and have Excel format the date, it is correctly interpreted. From that I am assuming I have a