Question: how to export data of a table as insert query in teradata sql assistant?
Answer: Login to the Source Database using Teradata SQL Assistant. ( ... 
Paste the Source SQL Query in the "Query" window.
Select the following Menu Option "File=>Export Results"
Go to "Tools=>Options" and select the Date Format as 'YYYY-MM-DD'.