[Tutor] Feedback on coding style

Alan Gauld alan.gauld at yahoo.co.uk
Mon May 9 19:29:49 EDT 2022


On 09/05/2022 22:51, Dennis Lee Bieber wrote:

> 	In particular you will want to read about SQLite3's data model
> https://www.sqlite.org/datatype3.html (there are only TEXT, INTEGER, REAL,
> and BLOB data types -- the DDL parser accepts most any RDBM data
> declaration and maps them to the closest 

In case anyone is worrying about an obvious gap, sqlite has
a set of functions for manipulating/comparing dates/times
which are stored internally as formatted strings.

So although there is no DATETIME type you can still do the
usual date/time manipulations you'd expect with a database.

-- 
Alan G
Author of the Learn to Program web site
http://www.alan-g.me.uk/
http://www.amazon.com/author/alan_gauld
Follow my photo-blog on Flickr at:
http://www.flickr.com/photos/alangauldphotos




More information about the Tutor mailing list