on 04-27-2009 2:24 PM
Hi everybody,
I want to use a SQL expression, where a decimal(19) which contains a date (as long).
The SQL-statement should format the decimal into a date-format.
Sample:
Field has value = 1240524000000 which is as date = 24.04.2009 10:39:00
SELECT TO_DATE('1240524000000', 'YYYYMMDD') FROM myTABLE
does not work.
I know that this is XI/PI forum. But maybe somebody has experience with this.
Please note: I do not want to convert in Mapping! I want to convert via the JDBC-Adapter
Thanks, regards
Mario
Edited by: Mario Müller on Apr 27, 2009 9:33 AM
Hi Mario,
SELECT statement must have exactly one <access> element, try with the below statement.
SELECT TO_DATE('1240524000000', 'YYYYMMDD') as col1 FROM myTABLE
and If there is no <key> element, or if there is a <key> element but it is empty, it might cause problem check with this.
Regards,
Prasanna
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
[http://www.mcs.csueastbay.edu/support/oracle/doc/10.2/server.102/b14200/functions183.htm]
see the example here
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
HI Mario,
Just googled it in the web.
see if this is relevant to you.
http://bytes.com/groups/ibm-db2/465990-convert-decimal-date
Regards,
Ravi
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 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.