sql日期时间转换为hql

Question

我正在处理以下查询：

SELECT att.AttendenceCD, convert(varchar, att.AttDate, 101) AttDate, att.EmployeeCD
FROM Attendance att
where att.EmployeeCD = 2234 and att.AttDate = '11/02/2011'

如何将此查询转换为 HQL？

Answer 1

检查这个。我希望它能

SELECT att.AttendenceCD, convert(varchar(10), att.AttDate, 101) AttDate, att.EmployeeCD
FROM Attendance att
where att.EmployeeCD = 2234 and att.AttDate = '11/02/2011'

以其他方式发挥作用

SELECT att.AttendenceCD, cast(att.AttDate, datetime(101)) AttDate, att.EmployeeCD
FROM Attendance att
where att.EmployeeCD = 2234 and att.AttDate = '11/02/2011'