Catalog Directory Indexing Error

Hi,

I'm getting the following error when I try to index my catalog folder:
Source: Microsoft SQL Server Native Client 10.0
Description: The conversion of a varchar data type to a datetime data type resulted in an out-of-range value.
query=INSERT INTO pcImageDirectory (pcImgDir_Name,pcImgDir_Type,pcImgDir_Size,pcImgDir_DateUploaded,pcImgDir_DateIndexed) VALUES('BBOOB-ISSO-AVC_LI.jpg','JPEG image',92468,'26/8/2011 6:50:07 PM','5/10/2011 6:50:07 PM')
Request Method: GET
URL: /shop/pc/imageDir.asp


I recently transferred my site to a new host, so I thought it might be related, but I tried the same thing on the old host which is still up and running and I received the same error.

I haven't touched any files on the old host in probably six months, besides uploading the security update that was released last month...


Here is what my current host had to say about the error:
The database column is set to (datetime , null) the varchar is being converted to the datatime datatype,
The issue might stem from the inclusion of the 'PM' chars in the string,
The MS documentation for the datatype indicates that times that are specific to the second need to be in 24 hour format,

The error that you are receiving is due to a datatype mismatch, this is inherent in the definition of the database tables and not something that is a server variable.
I have attached a screen shot of the table in question so that you can check and ensure that the data types that are in the table are the ones that you have intended.



Can anyone help me out with this?

Thanks.