sql 时间处理 字符串截取

时间处理
sql：
SELECT p.perNum ‘学号’, p.perName ‘姓名’,c.collegeName ‘学院’,m.majorName ‘专业’,m.majorNum’专业代码’,dic1.dataItemName’学生类型’,
rd2.dataItemName’录取类别’,t.grade’年级’,p.mobilePhone ‘电话’,p2.perName ‘导师姓名’,
date_format(a.abroadStartDate,’%Y-%m-%d %H:%i:%s’) ‘出国时间’,date_format(abroadEndDate,’%Y-%m-%d %H:%i:%s’) ‘归国时间’

字符串截取;
hql:
String sql = “select a.activityId,p.pointId,b.birdId,substring(cast(p.code as string),1,2) as x,”
+ "substring(cast(p.code as string),3,2) as y,b.birdName "
+ "from BirdActivitySituation a,BaseBirdInfo b,BirdActivityPoint p where p.activityId = a.activityId and b.birdId = a.birdId ";

控制显示多少条
sql:
select XXXXXXX limit param1, param2
param1 : 开始搜索的指针 .从0开始计。param2 : 搜索的条数。

例：前四条记录：SELECT * FROM table limit 0,4;
select XXXXXXX limit 10; //显示前10条

hql:
List list = this.queryForList(hql,0,10); //begin,count