Notice (2018-05-24): bugzilla.xamarin.com is now in
Please join us on
Visual Studio Developer Community and in the
Mono organizations on
GitHub to continue tracking issues. Bugzilla will remain
available for reference in read-only mode. We will continue to work
on open Bugzilla bugs, copy them to the new locations
as needed for follow-up, and add the new items under Related
Our sincere thanks to everyone who has contributed on this bug
tracker over the years. Thanks also for your understanding as we
make these adjustments and improvements for the future.
Please create a new report on
GitHub or Developer Community with
your current version information, steps to reproduce, and relevant error
messages or log files if you are hitting an issue that looks similar to
this resolved bug and you do not yet see a matching new report.
Created attachment 19778 [details]
Sample IOS app to easily reproduce the issue
Issue with Xamarin 6.1.5 and Mono.Data.Sqlite assembly version 18.104.22.168: When we store UTC DateTime values with UTC Kind in SQLLite(DateTimeKind=Utc was set in the connection string), the values retrieved had a Local datetime format with Local Kind instead of UTC format.
To reproduce it : Use the attached IOS app
1/ Create a db in SQLite, set the connection string with DateTimeKind=Utc.
2/ Insert in a table a UTC datetime with UTC Kind.
3/ Retrieve the date stored from the db : the date retrieved has a Local format with a local kind!
-> the retrieved date should be in the UTC format with a UTC kind
Note : if you run the same attached app on Xamarin 6.0.2 you get a date in UTC but with Unspecified kind !!
Thanks For your help
I have confirmed the bug with the following environment and that it happens when using the provided code and when the data is retrieved via a reader.GetDateTime(). Reassigned to the mono team.
Env used to confirm the bug:
=== Xamarin Studio Community ===
Version 6.1.5 (build 0)
Installation UUID: 01060673-5bee-4cf4-a4c2-5e36a18d39a2
Mono 4.8.0 (mono-4.8.0-branch/e8f4c7c) (64-bit)
GTK+ 2.24.23 (Raleigh theme)
Package version: 408000289
=== NuGet ===
=== Xamarin.Profiler ===
=== Apple Developer Tools ===
Xcode 8.2.1 (11766.1)
=== Xamarin.Mac ===
Version: 22.214.171.1249 (Xamarin Studio Community)
=== Xamarin.Android ===
Version: 126.96.36.199 (Xamarin Studio Community)
Android SDK: /Users/mandel/Library/Developer/Xamarin/android-sdk-macosx
Supported Android versions:
4.0.3 (API level 15)
4.3 (API level 18)
4.4 (API level 19)
5.0 (API level 21)
6.0 (API level 23)
SDK Tools Version: 25.1.6
SDK Platform Tools Version: 24.0.0
SDK Build Tools Version: 23.0.2
Java SDK: /usr
java version "1.7.0_71"
Java(TM) SE Runtime Environment (build 1.7.0_71-b14)
Java HotSpot(TM) 64-Bit Server VM (build 24.71-b01, mixed mode)
Android Designer EPL code available here:
=== Xamarin Android Player ===
Location: /Applications/Xamarin Android Player.app
=== Xamarin.iOS ===
Version: 10.5.0.426 (Xamarin Studio Community)
Build date: 2017-02-10 11:26:02+0100
=== Xamarin Inspector ===
Build date: 11/15/2016 10:13:59 PM
=== Build Information ===
Release ID: 601050000
Git revision: 7494718e127af9eaec45a3bd6282d3da927488bd
Build date: 2017-01-17 10:31:01-05
Xamarin addins: c92d0626d347aaa02839689eaac2961d24c9f446
Build lane: monodevelop-lion-cycle8
=== Operating System ===
Mac OS X 10.12.3
Darwin MacBook-Pro.local 16.4.0 Darwin Kernel Version 16.4.0
Thu Dec 22 22:53:21 PST 2016
=== Enabled user installed addins ===
Addin Maker 1.3.2
StyleCop Support 188.8.131.52
Xamarin Inspector 184.108.40.206
Egor, could you look into it. It could be fixed by our recent changes there but needs to be checked
*** This bug has been marked as a duplicate of bug 46929 ***
Thanks for the test case!