TO_char函数的使用（将最完整的日期格式转化成只有年月日）

TO_char：是格式化函数，将数字和日期转化成字符型
1，完整的日期格式

SELECT A.last_activity_date
FROM IFSAPP.SHOP_ORDER_OPERATION A
WHERE ORDER_NO='1946231FU1'

2，只有年月日

select to_char(A.last_activity_date,'yyyy/MM/dd ') 
FROM IFSAPP.SHOP_ORDER_OPERATION A
WHERE A.ORDER_NO='1946231FU1'

参考：
1.https://blog.csdn.net/xiaohuihui821/article/details/78652958
2.https://www.cnblogs.com/aipan/p/7941917.html