Quote Originally Posted by yxez
Doesnt it contain time if u default it to sysdate dear?

That would be a dumb design/coding.. you shud have used trunc(sysdate) while laoding.. makes lots of sense.