[EMAIL PROTECTED] wrote:
I did use date as a column name but I'll change that.
Also, I'm trying to select the contents of each column for each recors
and do this date calculation but apparently I cannot do both at the same
time?
I can do SELECT * from table;
but can't do SELECT id, agent, ad
I did use date as a column name but I'll change that.
Also, I'm trying to select the contents of each column for each recors
and do this date calculation but apparently I cannot do both at the same
time?
I can do SELECT * from table;
but can't do SELECT id, agent, ad_type, date_add('submit',
[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 m
On Monday 31 March 2003 18:27, 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;
>
> 'dat
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 th
