Hi,

I have a table that has a datetime field. The table contains numerous records.
Is there a command or a function that I can use to convert all the seconds of the datetime fields to zero?

example: 12/05/01 09:08:35 AM change to 12/05/01 09:08:00 AM

any help will be greatly appreciated.

Thanks in advance