如何将日期格式查询从mm / dd / YYYY更改为m / d / YY?
例如从03/01/2019至3/1/19
select user_id, strftime('%m/%d/%Y', min(date)) as start_date, strftime('%m/%d/%Y', max(date)) as end_date, log as status,
julianday(max(date)) - julianday(min(date)) + 1 as length
from (select users_log.*,
row_number() over (partition by user_id, log order by date) as seqnum
from users_log
) users_log
group by user_id, log, date(date, '-' || seqnum || ' day')
order by min(date)
您可以将天,月和年的每一天与对整数的隐式转换连接起来,0
以除去前导s:
(date + 0) || '/' || (substr(date, 4, 2) + 0) || '/' || substr(date, -2)
更改date
为您的列的名称。
参见演示。
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句