|
Posted by Mick White on 10/14/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
[Back to original message]
|