[ale] MySQL dates

[Emil P. Man]

Chris Fowler wrote:

>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
>http://www.ale.org/mailman/listinfo/ale
>
>
>  
>
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 
"date" data type in mySQL.