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
Music Rocks
www.musicreserve.blogspot.comSuccess is 1% Inspiration & 99% Perspiration
God Sometimes Delays His Help to Test Our Faith and Energize Our Prayers
Our Boat May Be Tossed While He Sleeps, But He Wakes Up Before it Sinks.