How to update a Date Field?

        Somehow in my database table, I have a date field that only has the format '02-NOV-98'. I would like to do an update statement that appends the date with 12:00 PM. I have tried and tried and cannot get the date to accept the hour of time. How do you do it?

Thanks, Sean Dolan

PS If you could, reply to the group or my personal mail: sean_at_3si.com

Thanks Again! Received on Thu Dec 10 1998 - 11:35:56 CST