kendoui grid 时间控件显示到月

1、 grid 列中加属性   editor: dayHourDropEditer （方法名）

2、 function dayHourDropEditer(container, options) {
            $(" <input id=" + options.field + "   name=" + options.field + "  />")

                .appendTo(container)

                .kendoDatePicker({ 
                    format: "yyyy-MM",
                    depth: "year",
                    start: "year" 
                });
        }

3、时间控件单独

$("#名称").kendoDatePicker({ 
                    format: "yyyy-MM",
                    depth: "year",
                    start: "year" 
                });

sql

-- SQLServer获取年月日，时分秒 
   -- SELECT GETDATE() as '当前日期',DateName(year,GetDate()) as '年',DateName(month,GetDate()) as '月',DateName(day,GetDate()) as '日',DateName(dw,GetDate()) as '星期',DateName(week,GetDate()) as '周数',DateName(hour,GetDate()) as '时',DateName(minute,GetDate()) as '分',DateName(second,GetDate()) as '秒'
-- 日期年月日102. 120-  108  时分秒:
-- select CONVERT(varchar(11) ,getdate(), 102) as 'Date'
 
-- delete from CollectInstructionDetails
--where CreationTime>= DATEADD(HOUR,-30,GETDATE())

--delete from CollectInstructionPoints
--where CreationTime>= DATEADD(HOUR,-30,GETDATE())

--delete from CollectInstructions
--where CreationTime>= DATEADD(HOUR,-30,GETDATE())