[no subject]

SELECT col1, DATE_FORMAT(date_col, "%c-%d-%y") as dtime WHERE dtime BETWEEN
'8-18-04' AND '8-25-04';


On Wed, 25 Aug 2004 17:38:33 -0400
James Sumners <james at sumners.ath.cx> wrote:

>  SELECT col1, DATE(date_col, "%c-%d-%y") as dtime WHERE dtime BETWEEN
>  '8-18-04' AND '8-25-04';

-- 
James Sumners
<a  rel="nofollow" href="http://ug.dyndns.org/~jsumners/";>http://ug.dyndns.org/~jsumners/</a>

&quot;All governments suffer a recurring problem: Power attracts pathological
personalities. It is not that power corrupts but that it is magnetic to the
corruptible. Such people have a tendency to become drunk on violence, a
condition to which they are quickly addicted.&quot;

Missionaria Protectiva, Text QIV (decto)
CH:D 59


</pre>
<!--X-Body-of-Message-End-->
<!--X-MsgBody-End-->
<!--X-Follow-Ups-->
<hr>
<!--X-Follow-Ups-End-->
<!--X-References-->
<ul><li><strong>References</strong>:
<ul>
<li><strong><a name="00679" href="msg00679.html">[ale] Searching by dates in MySQL</a></strong>
<ul><li><em>From:</em> cfowler at outpostsentinel.com (Christopher Fowler)</li></ul></li>
<li><strong><a name="00683" href="msg00683.html">[ale] Searching by dates in MySQL</a></strong>
<ul><li><em>From:</em> james at sumners.ath.cx (James Sumners)</li></ul></li>
</ul></li></ul>
<!--X-References-End-->
<!--X-BotPNI-->
<ul>
<li>Prev by Date:
<strong><a href="msg00683.html">[ale] Searching by dates in MySQL</a></strong>
</li>
<li>Next by Date:
<strong><a href="msg00685.html">[ale] Mail Delivery (failure ale@ale.org)</a></strong>
</li>
<li>Previous by thread:
<strong><a href="msg00683.html">[ale] Searching by dates in MySQL</a></strong>
</li>
<li>Next by thread:
<strong><a href="msg00681.html">[ale] Bycotting B$ (was Re: If you're on Bellsouth DSL,	I recommend changing providers.)</a></strong>
</li>
<li>Index(es):
<ul>
<li><a href="maillist.html#00684"><strong>Date</strong></a></li>
<li><a href="threads.html#00684"><strong>Thread</strong></a></li>
</ul>
</li>
</ul>

<!--X-BotPNI-End-->
<!--X-User-Footer-->
<!--X-User-Footer-End-->
</body>
</html>