java - 在mysql中将mysql日期格式转换为dd-mmm-yyyy

Question

我维护了一个 start_date 为“日期”数据类型的表，现在我想以 dd-mmm-yyyy 格式显示日期。

public static BusObjectIterator<com.timesheetmd.weeksView> weeksOfYear(int year)
{
    String queryText = "SELECT `id`, `year`, CONCAT(CAST(`start_date` AS CHAR), ' to ', CAST(`end_date` AS CHAR)) AS 'week' FROM `weeks` WHERE `weeks`.`year` = :year AND end_date <= CURRENT_DATE ORDER BY start_date DESC";
QueryObject query = new QueryObject(queryText);
query.addParameter("year", "weeks.year ", QueryObject.PARAM_INT,year);//NOPMD
query.setResultClass(weeksView.class);
return query.getObjects();
}

因为我想以 BusObjectIterator 的形式返回结果。是否可以更改查询本身的日期格式？

Answer 1

您需要 DATE_FORMAT(start_date,'%d-%b-%Y') 而不是您的 CAST(...AS CHAR)。

这是 DATE_FORMAT() writeup .