int hour=c.get(Calendar.HOUR_OF_DAY);int minute=c.get(Calendar.MINUTE);int second=c.get(Calendar.SECOND);int ms=c.get(Calendar.MILLISECOND);serialNo=(long)(year*10000+month*100+day);serialNo=serialNo*...
when '00:00' then '24:00' else right(CONVERT(VARCHAR(13),DATEADD(hour,NUMBER+1,@BDATE),21)+':00',5)end as dt isnull(b.num,0)as num FROM MASTER.SPT_VALUES as a left join(select CONVERT(VARCHAR(13),...