I'm a little confused with the real difference between Date and TimeStamp datatypes . . . in some sources I found that the difference is that TimeStamp stores fractional seconds and Date don't.
But Date datatype stores time information ? I know you can execute this statement and it is right TO_DATE('1999-12-01 11:00:00','RRRR-MM-DD HH:MI:SS') , but when select a Date datatype always displays only the date but not the time.
THKS !!!