Im having a problem getting the date and time function in oracle.
my table is as follows,
Create table dates (v_date DATE );
INSERT INTO dates values(To_date ('23 February 2003 10:51', 'DD Month YYYY HH:MI'));
which is all fine, but when i do a select on that table i just get the date back... i need to have the time as well, as later i will be checking it in order to meet some requirements,
anyhelp would be appreciated,