| Ticket Hash: | e783306b26b7b5f22188f6166761141a04c8a6df | ||
| Title: | DateTimekind doesn't work | ||
| Status: | Closed | Type: | Incident |
| Severity: | Important | Priority: | Medium |
| Subsystem: | Convert | Resolution: | Works_As_Designed |
| Last Modified: |
2018-01-24 17:46:13 7.44 years ago |
Created: |
2017-12-06 13:50:26 7.57 years ago |
| Version Found In: | 1.0.106 System.Data.SqLite.Core | ||
| User Comments: | ||||
anonymous added on 2017-12-06 13:50:26:
Hi,
I have a test which:
1. create object with property of type DateTime to which I assign a DateTime.UtcNow
2. save this object to db
3. query db for this object
4. in result I get a object with property of type DateTime, but with Date with kind set to `Local` instead of `UTC`.
I try to specify a DateTimeKind in connectionstring, but it didn't helps.
var connection = new SQLiteConnection("DateTimeKind=Utc;Data Source=:memory:");
When I work with legacy SqLite.x64 ver. 1.0.76 everything works fine.
Short disclaimer I don't want to use System.Data.SqLite because I don't want to get EntityFramework as a dependency to my project.
Thanks in advance,
Michał
mistachkin added on 2018-01-24 16:28:12: I'm unable to reproduce this issue. Do you have a short example that demonstrates the issue? | ||||