I'm trying to do a query like this on a table with a DATETIME column.
SELECT * FROM table WHERE the_date = 2011-03-06T15:53:34.890-05:00
I have the following as an string input from an external source:
I need to perform a query on my database table and extract the row which contains this same date. In my database it gets stored as a DATETIME and looks like the following:
I can probably manipulate the outside input slightly ( like strip off the -5:00 ). But I can't figure out how to do a simple select with the datetime column.
I found the convert function, and style 123 seems to match my needs but I can't get it to work. Here is the link to reference about style 123