on 07-14-2009 10:34 AM
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?
informix return result is 09-1-2
use function TransformDate
from 'yy-MM-dd' to 'yyyy-MM-dd'
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.