本来打算将日期格式化然后返回
select to_char(time,'yyyy-MM-dd hh:mm:ss') as start_time, phone_start_time as time from xxx
结果
然后就这样上线了,后续才发现不对劲,改为
select to_char(phone_start_time,'yyyy-MM-dd HH24:MI:ss') as start_time, phone_start_time as time from xxx
正常了
然后想在返回格式里面加个T 变成这样”2021-03-17T13:22:21,一想那还不简单,改成这样
select to_char(phone_start_time,'yyyy-MM-ddTHH24:MI:ss') as start_time, phone_start_time as time from xxx
结果变成这样了
最后解决方法是,把T换成了逗号然后代码里替换