[ale] MySQL dates

[james at sumners.ath.cx]

I have found that the DATETIME column type is handy. It gives you all
the information you need to reformat it in a query later.

On Tue, Mar 02, 2004 at 10:21:05AM -0500, 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

-- 

I used to be interested in Windows NT, but the more I see of it the more it looks like traditional Windows with a stabler kernel. I don't find anything technically interesting there. In my opinion MS is a lot better at making money than it is at making good operating systems.  -- Linus Torvalds