Database

Making Date Times

SELECT Left(Replace(Convert(varchar, dateadd(month, -3, getdate()), 112), ':', ''), 6) + '01' AS DateField?

SELECT Replace(Convert(varchar, getdate, 108), ':', '') AS TimeField?