MySQL Forums
Forum List  »  General

Advanced Search
New Topic

Re: Convert_TZ
Posted by: Peter Brawley
Date: December 05, 2018 11:52AM

SELECT CONVERT_TZ('2019-01-01 12:00:00', 'UTC', 'Europe/London') returns the literal date and timezone you gave it.

Try CONVERT_TZ(Curdate(), 'UTC', 'Europe/London').

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
Convert_TZ
Richard Creer
December 05, 2018 08:48AM
Re: Convert_TZ
Peter Brawley
December 05, 2018 11:52AM
Re: Convert_TZ
Richard Creer
December 06, 2018 07:30AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.