22 May 18:02
type problem with store using odbc
Hello,
I have a problem with a program dealing with a PostgreSQL database through ODBC which seems to work well with
all types except DATE_TIME. The piece of code which don't work as expected is:
l_any: ANY
l_any is affected from the database through Eiffel mechanism.
if attached {DATE_TIME} l_any as l_r_date_time then
-- some treatment
end
When debugging, in the debug windows, l_any is displayed as a DATE_TIME object with the value 05/21/2012
3:23:28.000 PM, but the if clause is considered as False. An other effect is that it skips the
milliseconds, the PostgreSQL value is 2012-05-21 15:23:28.42+02.
I precise that l_any is not recognized as an other type, neither STRING_8 nor STRING_32 unless I make a conversion.
Does someone have an idea?
Regards,
Philippe
[Non-text portions of this message have been removed]
------------------------------------
RSS Feed