MySQL Forums
Forum List  »  General

Re: Convert_TZ
Posted by: Richard Creer
Date: December 06, 2018 07:30AM

Thanks. I think I've got it.

SELECT UTC_TIMESTAMP(), CONVERT_TZ(UTC_TIMESTAMP(), 'UTC', 'Europe/London')
returns the expected results depending on 'when' I run it.

Towards the end of March we'll find out if my code does what I want it to do!

Options: ReplyQuote


Subject
Written By
Posted
December 05, 2018 08:48AM
December 05, 2018 11:52AM
Re: Convert_TZ
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.