sql java中的相关函数

java 取当前日期
Date d=new Date();
SimpleDateFormat sdf=new SimpleDateFormat("yyyy-MM-dd");
String str=sdf.format(d);
//取部分时间
GregorianCalendar g=new GregorianCalendar();
System.out.println(g.get(Calendar.YEAR));
System.out.println(g.get(Calendar.MONTH)+1);

sqlserver相关函数
例: 取系统time getdate(),取部分time datename(weekday,'1999-10-10')
    转换convert("类型",date,"长度")
    转换成日期类型cast('1999-09-10' as datatime)

SELECT user_id, COUNT(title) AS shuliang, DATENAME(weekday, CONVERT(char(10),
      [date])) AS weekday, MONTH([date]) AS Expr1, DAY([date]) AS Expr2
FROM bbstitle
WHERE ([date] BETWEEN '2007-04-10' AND GETDATE())
GROUP BY DATENAME(weekday, CONVERT(char(10), [date])), user_id, MONTH([date]),
      DAY([date])
ORDER BY user_id