I have a column with a DATE format;
I need to format the output, but using the <select> query of this determined column.
I must use ( due to my VC++ program requirements) the next command:
select * from MY_TABLE
Using only this statement the output format is YY-MM-DD and I need YY-MM-DD-HH-MM-SS.
I know how to use TO_CHAR and in fact using SQL*Plus works well.
It's possible to format a column inside the <select * from MY_TABLE> statement?