LAE

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: shirley ramalho

hello,

i am working with an oracle database .

My field name is: C536971040
The information it contains is: 1331233200

In my JDBC, I am using the following command:
SELECT TO_DATE('01/01/1970 00:00:00','mm/dd/yyyy hh24:mi:ss')+ C536871040/(24*60*60)
FROM ARADMIN.T32
where c1='000037'

when I run it, I don't get any error messages, however, when I try to open the records, i get the following error message:

header record, field1: Bad field type specifier u"'00:00', "bdate", assuming type 'string'
Attention: Attempting to skip these errors, behaviour may be compromised.
if this file is saved as brd format, the file will be presented with error, but if is saved as excel, only valid data will be converted.

This command works in Toad and the result i get is:
16/08/1997 7:08:46 pm

Does anybody know how i can get the same results using lavastorm ?

Thank you

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: stonysmith

Yes, it works in Toad, but what column name do you get?

thy this:
SELECT TO_DATE('01/01/1970 00:00:00','mm/dd/yyyy hh24:mi:ss')+ C536871040/(24*60*60) AS MYDATE

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: shirley ramalho

Tony,

you're a life saver !!!! it DOES work....
thank you very very much !!!!

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: shirley ramalho

Hi Tony,

something weird happened
i am running the same code as I did last time and am getting an error:
"Error for join
Error initializing expert output
unrecognized token: 'TO_DATE'
1969-12-29 11:50:06.168;WARN: unrecognized token: 'TO_DATE'

Any idea what could be ?

Thank you.

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: rboccuzzi

Can you post your join node? It isn't clear from the error above exactly what is happening, so we would need more information to help.

Cheers
Rich