[no subject]

>What is the best way to store dates in a datebase?  I'm currently
>storing them as the a string of output from the date command.  That
>becomes a problem when I do an order by date and select based on date.
>I would like to store them so I can order them correctly and also do
>a select by date.  To generate reports. I'm using perl to generate all
>reports.
>
>Thanks,
>Chris
>
>
>_______________________________________________
>Ale mailing list
>Ale at ale.org
&gt;<a  rel="nofollow" href="http://www.ale.org/mailman/listinfo/ale";>http://www.ale.org/mailman/listinfo/ale</a>
&gt;
&gt;
&gt;  
&gt;
Look on the mysql web site. There they have definitions of all the data 
types supported by MySQL. I know for sure that they have at least one 
&quot;date&quot; data type in mySQL.


</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="00039" href="msg00039.html">[ale] MySQL dates</a></strong>
<ul><li><em>From:</em> cfowler at outpostsentinel.com (Chris Fowler)</li></ul></li>
</ul></li></ul>
<!--X-References-End-->
<!--X-BotPNI-->
<ul>
<li>Prev by Date:
<strong><a href="msg00041.html">[ale] MySQL dates</a></strong>
</li>
<li>Next by Date:
<strong><a href="msg00043.html">[ale] MySQL dates</a></strong>
</li>
<li>Previous by thread:
<strong><a href="msg00041.html">[ale] MySQL dates</a></strong>
</li>
<li>Next by thread:
<strong><a href="msg00043.html">[ale] MySQL dates</a></strong>
</li>
<li>Index(es):
<ul>
<li><a href="maillist.html#00042"><strong>Date</strong></a></li>
<li><a href="threads.html#00042"><strong>Thread</strong></a></li>
</ul>
</li>
</ul>

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