CONVERT_TZ

Sintassi

CONVERT_TZ(dt, da_tz, a_tz)

Spiegazione

CONVERT_TZ() converte un valore datetime dt dalla timezone specificata con da_tz alla timezone specificata con a_tz e restituisce il risultato. Le timezone (fusi orari) sono descritte alla pagina http://dev.mysql.com/doc/refman/5.1/en/time-zone-support.html. Questa funzione restituisce NULL se gli argomenti non sono validi.

Esempi

MariaDB [(none)]> SELECT CONVERT_TZ('2004-01-01 12:00:00','GMT','MET');
+-----------------------------------------------+
| CONVERT_TZ('2004-01-01 12:00:00','GMT','MET') |
+-----------------------------------------------+
| NULL                                          |
+-----------------------------------------------+
1 row in set (0.00 sec)

MariaDB [(none)]> SELECT CONVERT_TZ('2004-01-01 12:00:00','+00:00','+10:00');
+-----------------------------------------------------+
| CONVERT_TZ('2004-01-01 12:00:00','+00:00','+10:00') |
+-----------------------------------------------------+
| 2004-01-01 22:00:00                                 |
+-----------------------------------------------------+
1 row in set (0.00 sec)

MariaDB [(none)]> 

Commenti

Sto caricando i commenti......
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.