Answer the question
In order to leave comments, you need to log in
How to match different formats in teradata?
Hello everyone, in order to parse, I need to find the completion dates of the code in the database.
There is a start date of the action in the date format, and how many days it worked in the integer format (if I'm not confused, there is no access now).
I need to determine the end date of a job by bringing together the start and end of the job.
Tried the following solutions:
startdate + codeday*(INTERVAL '1' DAY)
startdate+codeday
to_char(startdate+codeday)
startdate + codeday*(INTERVAL '1' DAY)
- "interval filed overflow". to_char(startdate+codeday)
- execute function access to syslib
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question