在MySQL中,我想在名为btimestamp的字段中检索格式为:dd/mm/YYYY 的日期。请选择正确的方法( )
SELECT DATE_FORMAT(btimestamp,'%d/%m/%Y') AS bdate FROM ...
SELECT FORMAT_DATE(btimestamp,'%d/%m/%Y') AS bdate FROM ...
在MySQL中,我想在名为btimestamp的字段中检索格式为:dd/mm/YYYY 的日期。请选择正确的方法( )
SELECT DATE_FORMAT(btimestamp,'%d/%m/%Y') AS bdate FROM ...
SELECT FORMAT_DATE(btimestamp,'%d/%m/%Y') AS bdate FROM ...