To get column without milliseconds, do following conversion:

select convert(datetime,convert(char(19), getdate(),120))