[]
[我要回覆]
|
|||||
|
|||||
樓主 HB 
 發送站內信 |
請問：如何修改T-SQL語法，將第1∼5筆資料顯示成第6∼7筆資料格式？ SELECT DateTrade, DATE(DateTrade), strftime('%Y', DateTrade) as YEAR, STRFTIME('%Y-%m-%d', DateTrade) as ShortDate, substr(DateTrade,1, 4) || substr(DateTrade,5,2) || substr(DateTrade,7,4) as TTT FROM [0101]; 
|
||||
3648
78
4437
359
