Skip to Content
0
Former Member
Feb 06, 2015 at 08:37 AM

Hi experts I am facing issue while extracting date columns from SAP application

303 Views

Hi While extracting date fields I am facing some issue. In SAP end date format is DD.MM.YYYY and after importing the tables in BODS end the data preview for date columns are like YYYY.MM.DD. I have used various commands like to_char(exp,'YYYY/MM/DD),To_char(YYYYMMDD) , To_date(),CAST() but all the time it is giving warnings and limit is exceeding and ultimately the job is failing. Please help me resolving the issue