Hi poot,
Populating the column with data as you did in your first post INSERT is spot on.
Oracle stores both date and time in a DATE column
..... BUT .....
(by default) it only displays the date in a SELECT unless you tell it to do otherwise. Which is what jovery & slimdave are saying (the use of sysdate & dual was just for an example - you should replace them with "whn" and "table1" - without the "").
"The power of instruction is seldom of much efficacy except in those happy dispositions where it is almost superfluous" - Gibbon, quoted by R.P.Feynman
Reply With Quote