I am using the oracle 11g for backend database and ms access as front end.
I want to store only the time in table's column but when i use the datatype timestamp in a column it takes the date also.
like 30-DEC-99 06.00.00.000000000 AM
I want to store only 06.00.00 am. can anyone help me?
Thanks in advance.