取字段最大值 Max

取字段最小值 Min

取时间字段的月值 select month from life_unite_product ; select datepart from life_unite_product ; select datename from life_unite_product

取时间字段的年值 select year from life_unite_product ; select datepart from life_unite_product ; select datename from life_unite_product

取时间字段的天值 select datepart from life_unite_product ; select day from life_unite_product

取值的字段 contact.ValueField "name

取时间字段的秒值 select datepart from life_unite_product