I have set up a DTS job which copies data from an html page as the source and
uploads to a SQL Table.

One of the columns that is traferred is a Datetime column on the original
file the data for this datetime column shows this mm/dd/yy hh:mm 6/12/05
11:40 PM after the dts job 2005-12-06 23:40:00.000 this would be fine if it
were consistent.

File Source After the DTS (in the SQL table)
MM/dd/yy hh:mm yyyy-dd-mm hh:mm:ss.???
6/12/05 11:40 PM 2005-12-06 23:40:00.000
e.g
6/11/05 11:40 PM 2005-11-06 23:40:00.000
6/10/05 11:40 PM 2005-10-06 23:40:00.000
6/09/05 11:40 PM 2005-09-06 23:40:00.000
etc etc

But the Minute the date hits the 13th of the month the format changes

File source After the DTS (in the SQL table)
MM/dd/yy hh:mm yyyy-mm-dd hh:mm:ss
6/13/05 11:40 PM 2005-06-13 23:40:00.000

5/13/05 11:40 PM 2005-05-13 23:40:00.000
5/14/05 11:40 PM 2005-05-14 23:40:00.000

etc...

Not sure how i can keep it consistent?

Thanks

Simon Jelinek