cancel
Showing results for 
Search instead for 
Did you mean: 

data format problem in jdbc to proxy

Former Member
0 Kudos

I found that the date format of SQL query is not certain, such as '2008-01-08' or '09-1-2'

How to get a fixed format string?

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

informix return result is 09-1-2

use function TransformDate

from 'yy-MM-dd' to 'yyyy-MM-dd'

AaronLong
Advisor
Advisor
0 Kudos

Hi,

SAP Note 831162 - FAQ: XI 3.0 / PI 7.0 / PI 7.1 JDBC Adapter

Q3: Date Field Handling

should have your problem resolved.