Explicitly converts an expression from one data type to a different data type. The cast operator can also function as a truncation operator. codepage (DT_STR,30,1252) casts 30 bytes, or 30 single ...
to The DatePart Specified of the Given Date. SELECT DATEADD(DAY,20,'2012-08-30 19:45:31.793'); --Returns '2012-09-19 19:45:31.793' SELECT DATEADD(MONTH,2,'2012-08-30 19:45:31.793'); --Returns '2012-10 ...