To_date function through Java shows timestamp

[mpavithra]

Hi All,

When i give the select query from toad, SELECT TO_DATE (TO_CHAR (SYSDATE, 'MM/DD/YYYY'), 'MM/DD/YYYY')
FROM DUAL
, gives me as the date with proper date format. But when i go through my java program, i am getting with timestamp.

Actually, my desired output is the date column that i need to show in mm/dd/yyyy format as well as i want it as to_date, so that it will sort by using the date. If, i use the to_char, then it is sorting in character.

Can some one help in solving this:)

[Norm]

Can you post the java code that you go thru to show the date?
The SimpleDateFormat class allows you to format it many different ways

[mpavithra]

Actually, i want to achieve through my oracle query. Because through Java I can achieve it. But, is there any way i can achieve through DB side.