Just confirming that the best way to move DateTime fields from SQL Server is to CAST them using:
FORMAT(CAST([DateTimeField] AS DATETIME), ‘yyyy-MM-dd HH:MM:ss’)
The reason I’m asking is that I received a conversion error on one of my Panoply jobs.
“Conversion failed when converting date and/or time from character string.”
Please sign in to leave a comment.