[EMAIL PROTECTED] wrote:
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 a string. Did you mean `date` ? You should not name a column `date`. That is a reserved word.
'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]
