DateTime column default string format (US)


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.
Advertisements


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s