Home Forums SQL Server 2008 T-SQL (SS2K8) sp_send_dbmail has formatting off on datetime when directing output to csv file RE: sp_send_dbmail has formatting off on datetime when directing output to csv file

  • Did you try changing your query to get the columns instead of using SELECT *? Probably a good idea in general, since it means you won't risk having columns which you may not want to have, show up in the result set.

    If you do it that way, you could also potentially try using CONVERT to change the DATETIME column into a VARCHAR column, formatted the way you want it. That might solve your problems?