<p>I have a database that one of the columns lists a time and date in the 'RFC850' format; I want my program to find the oldest date in the whole table... Can someone help me with this? I can't seem to find anything on Google like what i need to do.</p>
<hr/>**评论：**<br/><br/>kardianos: <pre><p>order by convert(datetime, mycol)
?</p></pre>caseynashvegas: <pre><p>Assuming this is a relational database, yes, this is SQL question, not a Go specific question. What is your database?</p></pre>SaturnsVoid: <pre><p>MySQL is what i am using</p></pre>caseynashvegas: <pre><p>Yes, then your sql statement would be <code>select top 1 * order by convert(<col>, datetime) from <table></code></p></pre>mohi666: <pre><p>I clicked on this thread to compare my age against others in this sub, thinking your title isn't related to coding. lol. </p></pre>Killing_Spark: <pre><p>Nobody would be shouting at you for doing so. 20 years old, so im pretty unlikely to win :/</p></pre>twek: <pre><p>I guess at 26 I'm the winner so far</p></pre>
