Posted by Todd on 10/08/06 20:33

Can't give you the exact why, but you can fix it in your SQL Select
statement.

"SELECT CONVERT(VARCHAR, yourDateField, 101) FROM yourTable"

Will return your date value in the mm/dd/yyyy format.

See http://msdn2.microsoft.com/en-us/library/ms187928.aspx

For more details.

[Back to original message]