I have a query that contains
CONVERT_TZ(NOW(),@@global.time_zone, 'Europe/Madrid')
as the value for an insert statement.
This has worked fine on several servers. Now, on a new one, that returns null causing an error.
What can be the cause?
Asked
Active
Viewed 149 times
0
matteo
- 2,934
- 7
- 44
- 59
-
1Are you getting any error messages? – danmullen Oct 21 '14 at 11:47
-
1Check [this answer](http://stackoverflow.com/a/14454465/2091410); hope it helps. – Ed Gibbs Oct 21 '14 at 11:49
-
possible duplicate of [convert\_tz returns null](http://stackoverflow.com/questions/14454304/convert-tz-returns-null) – matteo Oct 21 '14 at 19:40
-
@EdGibbs right, that was it. – matteo Oct 21 '14 at 19:40
-
@danmullen no, no error message. – matteo Oct 21 '14 at 19:41