[ale] MySQL dates

[esoteric at 3times25.net (Geoffrey)]

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.

Every database I've ever used has had a date type, that is what you 
should use.

-- 
Until later, Geoffrey                     Registered Linux User #108567
Building secure systems inspite of Microsoft