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'.