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