Posted by Mick White on 10/09/65 11:27

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

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

[Reply to this message]