Cast string to date in SQL (dbeaver) ... SELECT CAST(SUBSTRING(DT,6,2)+'/'+SUBSTRING(DT,4,2)+'/'+'20'+SUBSTRING(DT,2,2) AS DATE) FROM table. sql casting db2 ...
確定! 回上一頁