[fdo-trac] #641: SQLite Can't create a datetime column

[FDO]

#641: SQLite Can't create a datetime column
-----------------------------+----------------------------------------------
 Reporter:  bscott           |         Owner:  traianstanev
     Type:  defect           |        Status:  new         
 Priority:  blocker          |     Milestone:  3.5.0       
Component:  SQLite Provider  |       Version:  3.5.0       
 Severity:  1                |    Resolution:              
 Keywords:                   |   External_id:              
-----------------------------+----------------------------------------------
Comment (by bscott):

 I know that option would work
 but it's not a solution for us.

 I want my clients to be able to manage there database with standard
 SqlLite tools.
 When using UseFdoMetadata=TRUE it create a bunch of fdo metadata tables
 that make database
 administration a nightmare.
 Even if we have a AutoCAD Map to edit the SqlLite schema, it's pretty
 difficult to use views as source of data for a featureclass

 As quoted in the http://www.sqlite.org/datatypes.html document

 "Even though SQLite allows the datatype to be omitted, it is still a good
 idea to include it in your CREATE TABLE statements, since the data type
 often serves as a good hint to other programmers about what you intend to
 put in the column"

 So even if you store the date as string internally, it should not be very
 difficult to include DATE or TIMESTAMP in the CREATE TABLE statement

-- 
Ticket URL: <http://trac.osgeo.org/fdo/ticket/641#comment:5>
FDO <http://fdo.osgeo.org/>
Feature Data Objects