Posted by Mick White on 10/08/54 11:27

Stefan Rybacki wrote:

> Mick White wrote:
>
>> mysql> select * from G;
>> +------------+-----------+----------------+--------+
>> | first_name | last_name | modified | offset |
>> +------------+-----------+----------------+--------+
>> | Mick | White | 20050923102539 | -5 |
>> +------------+-----------+----------------+--------+
>> 1 row in set (0.00 sec)
>>
>> mysql> select ADDDATE(modified,INTERVAL -5 HOUR) from G;
>> +------------------------------------+
>> | ADDDATE(modified,INTERVAL -5 HOUR) |
>> +------------------------------------+
>> | 2005-09-23 05:25:39 |
>> +------------------------------------+
>> 1 row in set (0.02 sec)
>>
>> How could I substitute `offset` value for -5 ?
>>
>> mysql> select ADDDATE(modified,INTERVAL,offset HOUR) from G;
>>
>> This produces an error (server version: 4.0.25-standard)
>> Mick
>>
>
> What is the error you get? Did you try to enclose offset in `?

I found the problem:
mysql> select ADDDATE(NOW(),INTERVAL offset HOUR) as minus_5 from G;
+---------------------+
| minus_5 |
+---------------------+
| 2005-09-23 15:19:41 |
+---------------------+
1 row in set (0.00 sec)

I had a comma after`INTERVAL`

• Next in forum: Getting MySQL to start and keep started
• Prev in forum: Re: How to use a value in table in query?
• Thread view: Re: How to use a value in table in query?

[Reply to this message]