中关村在线

SQL Server里获得不包含时间部分的日期

另外，DateName()还可以获得到小时、时间、秒、星期几、第几周，分别如下： Select Datename(hour,GetDate())Select Datename(minute,GetDate())Select Datename(second,GetDate())Select Datename(weekDay,GetDate())Select Datename(week,GetDate ...
Ars Technica

2-digit day (SQL)

Isn't there an easy way to get a 2-digit day from a SQL query?<BR><BR>SELECT datepart(dd, getDate()); <BR><BR>will return "1" for July 1st. How can I get it to return ...