Please help me know how the below issue can be resolved.
Im trying to equate a timestamfield(casting to date formate ) with current_date in the where clause. and im getting 3899 Internal error in teradata SQL parser error.
Kindly help to know me how i can modify the code..Requirement is basically to retrive only current date data invariable of the timestamp.
Need more info about datatypes.
Btw you can equate timestamp to date without cast. Current_timestamp = date - works fine.
An Internal error like this should be reported to the Teradata support center. They will most likely need the DDL of the views/tables referenced. They will also likely be able to provide a workaround for your issue.
What was the workaround provided by Teradata for this issue? we are getting similar issue on one of Preprod environment but not on QA environment.
It is really best to open a new incident with Teradata support. It is not possible to determine if this issue is the same as the one in the original thread without analysis of the details.