主题：在统计查询中怎么样显示完整的日期例

参考代码

Dim cmd As New SQLCommand
Dim dt As DataTable
cmd.CommandText = "Select *, cstr(第十列) as 日期 from {表C}"

'sqlserver 改成 cmd.CommandText = "Select *, convert(varchar(10), 第十列, 120) as 日期 from {表C}"
dt = cmd.ExecuteReader()
'对临时进行分组统计
Dim b As New CrossTableBuilder("横向出货计划1",dt)
b.HGroups.AddDef("年份")
b.VGroups.AddDef("日期")
b.Totals.AddDef("第八列")
b.HorizontalTotal = True
b.VerticalTotal = True
b.Build()