We have a SQL 2000 DB that has a field called Date and another called time. There are over 500,000 records and the problem is that over the years people have input 12/3/1998 3:23:00 PM in the date field. I need a small SQL query or Application that will look at the date field and if it contains a Time that is takes this time and moves it to the TIME field and converts it to 24hour time like 15:23. The Caveat is that some date fields may not have a time and some may not have an AM or PM in this case it needs to be removed if there is a time and if the AM or PM is missing then it needs to be defaulted to "PM" (after 12:00AM)If the Date field does not have a time AND the Time Field does not have a time then it needs to add 12:00 to the Time Field. We have incuded an ACCESS Database EXAMPLE of the problem. REMEMBER the Actual database is in MS SQL
## Deliverables
Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. Complete copyrights to all work purchased.
## Platform
MS SQL or ASP (does not matter much as all it has to do is work)
## Deadline information
We need this ASAP as low-cost as possible