從資料庫匯出到excel表格時怎樣修改excel表格的日期格式?
- 2021-09-17
如題。 語句如下:
select qty2,qty,date_format(billDate,‘%Y年%m月%d日 %H:%i:%s’),changeType,volume,weight,sourceBillType,sourceBillNo,
convert(B。customerName using gb2312) as customerName,
convert(C。productName using gb2312) as productName,
convert(C。productSpec using gb2312) as productSpec,
convert(D。storageName using gb2312) as storageName into outfile ‘D:/test。xls’
from ST03_dayBooks A
left join car03_customer B on A。customerNo=B。customerNo
left join st00_storage_info D on A。storageNo=D。storageNo
left join car03_customer_product C on A。customerNo=C。customerNo and A。productNo=C。productNo
order by billDate desc
要求日期格式為yyyy-MM-dd形式的 但是excel裡面顯示的是######
有沒有人能教我下該怎麼改語句?
既然這樣就在Excel中修訂日期格式吧!
下一篇:為什麼過夜的茶水不能喝?