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?

in fact, selectSQL use NLS parameter for select a date. how i can change this in WM?