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;
give
> 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
> strftime and date but I
2 matches
Mail list logo
