Posted by Stefan Rybacki on 10/10/84 11:27

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 `?

• Next in forum: Re: How to use a value in table in query?
• Prev in forum: Re: Error 1045
• Thread view: Re: How to use a value in table in query?

[Reply to this message]