search

longde123 / csharp-sqlite

Automatically exported from code.google.com/p/csharp-sqlite
Other
0 stars 0 forks source link

DateTime flag 'localtime' not working #164

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
What steps will reproduce the problem?
1. Execute the following sql in any program: select datetime('now', 
'localtime') as test_date
2. See the string returned from the query

What is the expected output? What do you see instead?
E.g. now it is 26/6/2012 08:40 and the sql returns "2012-06-14 18:10:05"

What version of the product are you using? On what operating system?
Windows 7 64 Bit, developing with monodroid + windows phone

Please provide any additional information below.
If i don't use the localtime flag the sql works as expected

Original issue reported on code.google.com by tobias.k...@googlemail.com on 26 Jun 2012 at 6:41

GoogleCodeExporter commented 9 years ago 
[deleted comment]
GoogleCodeExporter commented 9 years ago 
using   3.7.7.1 + VFS all source files (changeset 71)

Original comment by tobias.k...@googlemail.com on 26 Jun 2012 at 6:53

GoogleCodeExporter commented 9 years ago 
This issue was closed by revision c329e3aa7975.

Original comment by noah.hart@gmail.com on 29 Jun 2012 at 10:16