Status: New Owner: ---- Labels: Version-3.5.0 Type-Bug Priority-Medium OpSys-Any Dist-Any Arch-Any Desktop-Any GUI-Any
New issue 476 by [email protected]: Sqlite3 returns date in different format from similar syntax http://code.google.com/p/gambas/issues/detail?id=476 1) On retriving date value from sqlite3 using syntax "select fldtime as fldtime from tbltest" returns date in different format (e.g. 2013-11-19 18:11:45.529) 2) GIVE THE FOLLOWING INFORMATIONS (if they are appropriate): Version: all 3.x Operating system: Linux Distribution: Ubuntu Architecture: x86 GUI component: GTK+ Desktop used: Gnome 3) I went through a lot of discussions on date problem in sqlite3. However I feel this problem can be sorted out easily. A date field is created in a table of sqlite3 database using gambas method (e.g. hTable.Fields.Add("fldtime", gb.Date)) and date value entered using gambas database-independent method. on executing syntax "select fldtime as fldtime from tbltest" returns date in standard date format used by gambas (e.g. 11/19/2013 18:11:45) However usins "AS" syntax i.e. "select fldtime as fldtime from tbltest" returns date in other string format (e.g. 2013-11-19 18:11:45.529) which is not recognized as date by gambas. 4) SQLite3 5) Step 3. 6) By doing that carefully, you have done 50% of the bug fix job! IMPORTANT NOTE: if you encounter several different problems or bugs, (for example, a bug in your project, and an interpreter crash while debugging it), please create distinct issues! Attachments: sqlite_date.tar.gz 5.2 KB -- You received this message because this project is configured to send all issue notifications to this address. You may adjust your notification preferences at: https://code.google.com/hosting/settings ------------------------------------------------------------------------------ Shape the Mobile Experience: Free Subscription Software experts and developers: Be at the forefront of tech innovation. Intel(R) Software Adrenaline delivers strategic insight and game-changing conversations that shape the rapidly evolving mobile landscape. Sign up now. http://pubads.g.doubleclick.net/gampad/clk?id=63431311&iu=/4140/ostg.clktrk _______________________________________________ Gambas-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/gambas-user
