MySQL Forums
Forum List  »  General

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').

Options: ReplyQuote

Written By
December 05, 2018 08:48AM
Re: Convert_TZ
December 05, 2018 11:52AM
December 06, 2018 07:30AM

Sorry, only registered users may post in this forum.

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.