If you just want to display it as a character you don't need to do the final date conversion. This should do the trick:
select to_char(to_date(indate,'DD/MM/YYYY HH:MI'), 'DD/MM/YYYY')
...
Type: Posts; User: u02sgb; Keyword(s):
If you just want to display it as a character you don't need to do the final date conversion. This should do the trick:
select to_char(to_date(indate,'DD/MM/YYYY HH:MI'), 'DD/MM/YYYY')
...