How to get date & time in one column?

[pashah72]

Hello

After executing an sql query, I get date & time in one column but I require
date in 'dd-mm-yyyy' format, when I give : to_date(datefieldname,
'dd-mm-yyyy' ), time disappears, when I give : to_Char(datefieldname,
'hrs:mm:ss' ), date disappears. How to get both(date & time in one column)

Looking forward for an early reply.

Thanks
:confused:

[Darknight]

What database are you using?
its 12:27am here... early enough for yea :p