[no subject]

Check out the documentation on MySQL's types:

<a  rel="nofollow" href="http://www.mysql.com/documentation/mysql/bychapter/manual_Column_types.html#Date_and_time_types";>http://www.mysql.com/documentation/mysql/bychapter/manual_Column_types.html#Date_and_time_types</a>

MySQL also has a set of functions to make date calculations easy (well,
easiER):

<a  rel="nofollow" href="http://www.mysql.com/documentation/mysql/bychapter/manual_Tutorial.html#Date_calculations";>http://www.mysql.com/documentation/mysql/bychapter/manual_Tutorial.html#Date_calculations</a>

HTH,

Adam


=====
-----------------------------------------------------------
Adam Levenstein                          cleon42 at yahoo.com
<a  rel="nofollow" href="http://www.geekpins.com";>http://www.geekpins.com</a>

All your badgers are belong to us.


</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="msg00040.html">[ale] MySQL dates</a></strong>
</li>
<li>Next by Date:
<strong><a href="msg00042.html">[ale] MySQL dates</a></strong>
</li>
<li>Previous by thread:
<strong><a href="msg00040.html">[ale] MySQL dates</a></strong>
</li>
<li>Next by thread:
<strong><a href="msg00042.html">[ale] MySQL dates</a></strong>
</li>
<li>Index(es):
<ul>
<li><a href="maillist.html#00041"><strong>Date</strong></a></li>
<li><a href="threads.html#00041"><strong>Thread</strong></a></li>
</ul>
</li>
</ul>

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