Skip to Content
avatar image
Former Member

data format problem in jdbc to proxy

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?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jul 14, 2009 at 09:53 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 14, 2009 at 10:49 AM

    informix return result is 09-1-2

    use function TransformDate

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

    Add comment
    10|10000 characters needed characters exceeded