To_date function through Java shows timestamp
When i give the select query from toad, SELECT TO_DATE (TO_CHAR (SYSDATE, 'MM/DD/YYYY'), 'MM/DD/YYYY')
, 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:)