[Gambas-user] Issue 476 in gambas: Sqlite3 returns date in different format from similar syntax

[gambas at ...2524...]

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 isaf... at ...626...: 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