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:
What database are you using?
its 12:27am here... early enough for yea :p