MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

MySQL 8.0 and DateTimeOffset and TIMESTAMP WITH TIME ZONE
Posted by: Name Nachher
Date: April 10, 2019 05:30AM

Hello!

I'm using MySQL 8.0 together with C# and .NET Connector.
I want to have a field like Oracle ones "TIMESTAMP WITH TIME ZONE", which is represented in C# as a DateTimeOffset.
This type has both, UTC info + time zone, so it can be displayed as local time too.

How can I read/write DateTimeOffset to Mysql database using C# (prefered type DateTimeOffset)? Which type do I use in the table?

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


Subject
Written By
Posted
MySQL 8.0 and DateTimeOffset and TIMESTAMP WITH TIME ZONE
Name Nachher
April 10, 2019 05:30AM
Re: MySQL 8.0 and DateTimeOffset and TIMESTAMP WITH TIME ZONE
Peter Brawley
April 10, 2019 07:57AM


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.