Quote Originally Posted by slimdave

(in the real world of course hire date is unlikely to have a time component, but I guess this is just an example?)
Doesnt it contain time if u default it to sysdate dear?