Since MS SQL 2012, you can use FORMAT, SELECT FORMAT([MyDateColumn], 'dd-MM.yyyy HH:mm') In MYSQL it will work SELECT DATE_FORMAT(date, '%Y-%m-%d %H:%i') AS ...
確定! 回上一頁