I'm trying go get a future date from a query that contains a datetime
column. I figured I would be able to use an alias in the query to
calculate the future date as follows:
select expires as date_add('date' + interval 180 days) from table;
'date' is the column where the datetime is stored in the table.
I'd really like to be able to do this calculation within my query rather
than pull the value and convert it for use in php.
TIA,
Ed
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
