I am having an issue when using Bteq in Linux.
Let's say I have a table in teradata that has two columns:
When I qu ery this table from Bteq in Linux the result is:
Is there a way to get the date format correct just like it exist in the table?
A DATE doesn't have a format, it's just formatted for display, internally it's an integer.
If you run that query in SQL Assistant there's a setting how to format dates, BTEQ doesn't know about that.
To get the desired format you have to specify it in your query::
select date_issue (format 'mm/dd/yyyy') ...