<p>How can I use .NET DataSet.Select method to search records that match a DateTime?
What format should I use to enter my dates in?</p>

[{'answer_id': 67696, 'author': 'Leo Moore', 'author_id': 6336, 'author_profile': 'https://Stackoverflow.com/users/6336', 'pm_score': 3, 'selected': True, 'text': "<p>The best method is dd MMM yyyy (ie 15 Sep 2008). This means there is no possiblity of getting it wrong for different Locals.</p>\n\n<pre><code>ds.select(DBDate = '15 Sep 2008')\n</code></pre>\n\n<p>You can use the DateFormat function to convert to long date format as well and this will work fine too.</p>\n"}, {'answer_id': 67753, 'author': 'creohornet', 'author_id': 9111, 'author_profile': 'https://Stackoverflow.com/users/9111', 'pm_score': 0, 'selected': False, 'text': '<p>I use the following for the SQL Select:</p>\n\n<pre><code>    public string BuildSQL()\n    {\n        // Format: CAST(\'2000-05-08 12:35:29\' AS datetime)\n        StringBuilder sb = new StringBuilder("CAST(\'");\n\n        sb.Append(_dateTime.ToString("yyyy-MM-dd HH:mm:ss"));\n        sb.Append("\' AS datetime)");\n\n        return sb.ToString();\n    }\n</code></pre>\n'}, {'answer_id': 14658794, 'author': 'user2034559', 'author_id': 2034559, 'author_profile': 'https://Stackoverflow.com/users/2034559', 'pm_score': 0, 'selected': False, 'text': '<p>To get an exact match you can use the <a href="http://msdn.microsoft.com/en-us/library/az4se3k1.aspx" rel="nofollow"><strong>Round-trip date/time pattern</strong></a>. For example</p>\n\n<pre><code>dataTable.Select(String.Format("DateCreated=\'{0}\'",_dateCreated.ToString("O")));\n</code></pre>\n'}]
['https://Stackoverflow.com/questions/67676', 'https://Stackoverflow.com', 'https://Stackoverflow.com/users/7277/']