DateTime column default string format (US)Posted: January 12, 2009
A datetime column's default conversion format to a string is mon dd yyyy hh:miAM (or PM).
If you want to work with the default, the WHERE clause will look like this:
....WHERE dtColumn Like '%Sep 9 2008%' to retrieve all September 9, 2008 records
Two spaces are needed for the day part. If the day part is one digit number,
you need to pad a space infront of it.