[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[ale] MySQL dates

Subject: [ale] MySQL dates
From: cfowler at outpostsentinel.com (Chris Fowler)
Date: Tue Mar 2 10:22:34 2004

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

Follow-Ups:
- [ale] MySQL dates
  - From: esoteric at 3times25.net (Geoffrey)
- [ale] MySQL dates
  - From: cleon42 at yahoo.com (Adam Levenstein)
- [ale] MySQL dates
  - From: mailinglists at synban.com (Emil P. Man)
- [ale] MySQL dates
  - From: james at sumners.ath.cx (james at sumners.ath.cx)

Prev by Date: [ale] Two SSH access questions
Next by Date: [ale] MySQL dates
Previous by thread: [ale] Two SSH access questions
Next by thread: [ale] MySQL dates
Index(es):
- Date
- Thread