I’ve got a value that looks like this: 5/18/2007 2:27:01 PMbecause it’s returned from the DateTime=Now() function.I need for it to look like this:518200722701I’ve googled datetime conversion ...

I am getting errors in T-SQL query... Conversion failed when converting datetime from character string. SELECT roA_tblUser.Email as Email FROM roA_tblUser UNION SELECT roA_tblUserAccount ...