[ale] MySQL dates

[cleon42 at yahoo.com (Adam Levenstein)]

Most DBs--and MySQL is no exception--have native date/time types other
than just strings (which, as you've noted, is rather inefficient and
unpleasant).

Check out the documentation on MySQL's types:

http://www.mysql.com/documentation/mysql/bychapter/manual_Column_types.html#Date_and_time_types

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

http://www.mysql.com/documentation/mysql/bychapter/manual_Tutorial.html#Date_calculations

HTH,

Adam


=====
-----------------------------------------------------------
Adam Levenstein                          cleon42 at yahoo.com
http://www.geekpins.com

All your badgers are belong to us.