Quote Originally Posted by abhaysk
That would be a dumb design/coding.. you shud have used trunc(sysdate) while laoding.. makes lots of sense.
+1

In general people wouldn't have a hire date that included a component like "10:15:27" ... it would just be a date. In fact I think that it's unlikely that sysdate would be a good default for a hire date -- almost certainly that would be populated "in advance".