hi,
i have a date in my DB (oracle 10.2) with time (2012-02-06 12:38:02)
I create an adapter SQL and i try to get this date.
and i never have the good time.
In output Field type i have 5 choices.
Result is :
java.sql.Date : (Object date) 06/02/2012 00:00:00 CET
java.util.Date : (Object date) 06/02/2012 00:00:00 CET
java.lang.string : (String) 2012-02-06
java.lang.object : (Object date) 06/02/2012 00:00:00 CET
SetAsString : (String) 2012-02-06
I try to write in expression with to_char
[TABLE]
[TR]
[TD]TO_CHAR(t1.DATE_DE_DERNIERE_MODIFICATION, ‘DD/MM/YYYY HH24:mi’)
I have an error
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[/TABLE]
but if i try with this :
[TABLE]
[TR]
[TD]TO_CHAR(t1.DATE_DE_DERNIERE_MODIFICATION, ‘DD/MM/YYYY’)[/TD]
[/TR]
[/TABLE]
that works but i don’t have time.
I try tu get this date with Dynamic SQL and i write only this :
SELECT t1.DATE_DE_DERNIERE_MODIFICATION FROM …
And it’s work! 
How can i resolved this point for SelectSQL?