用datediff(day,time1,time2)方法取当天所有记录

package test;

import java.util.List;

import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.Transaction;

import com.factory.HibernateSessionFactory;

public class QueryTest {

/**
* @param args
*/
public static void main(String[] args) {
// TODO Auto-generated method stub
Session session = HibernateSessionFactory.getSession();
Transaction tx = session.beginTransaction();
Manage m = null;
try{
Query q = session.createQuery(" [color=green]from Manage m where datediff(day,m.loadTime,getdate())=0[/color]");
List list = q.list();
tx.commit();
for(int i=0;i<list.size();i++){
m = (Manage)list.get(i);
System.out.print("adminId="+m.getId().getAdminId()+",adminName="+m.getId().getAdminName());
System.out.println(",adminPass="+m.getId().getAdminPass()+",loadTime="+m.getId().getLoadTime());
System.out.println("------------------------------------------------------");
}
}catch(Exception e){
e.printStackTrace();
}finally{
session.close();
}

}

}