|
Hey list I need a query like this: Select * from activities where act_date = today or any day
in the future I have made it work like this: Sselect * from activities where UNIX_TIMESTAMP()<
UNIX_TIMESTAMP(act_date) Problem is with this thing I have to manually add 23:59:59
to each activity date I enter in the database. I’m sure there is a better way so I can set my column
type to DATE instead of DATETIME now and use a better query. Any help? Thx Reinhart |
No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.300 / Virus Database: 265.8.8 - Release Date: 14/02/2005
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
