String sql = "select count(*) as mynum from Trade group by format(StockDate, 'yyyy-MM')";
这是按月查询的,其他以此类推。
这是按月查询的,其他以此类推。
日:
SELECT SJoinTime, ID FROM Sale where format(sjointime,'yyyy-MM-dd')=#2009-03-30#
另外可用datepart函数:
DatePart 函数
返回一个 Integer 值,其中包含给定 Date 值的指定组件。
Public Overloads Function DatePart( _
ByVal Interval As DateInterval, _
ByVal DateValue As DateTime, _
Optional ByVal FirstDayOfWeekValue As FirstDayOfWeek = VbSunday, _
Optional ByVal FirstWeekOfYearValue As
另外可用datepart函数:
DatePart 函数
返回一个 Integer 值,其中包含给定 Date 值的指定组件。
Public Overloads Function DatePart( _
ByVal Interval As DateInterval, _
ByVal DateValue As DateTime, _
Optional ByVal FirstDayOfWeekValue As FirstDayOfWeek = VbSunday, _
Optional ByVal FirstWeekOfYearValue As