'''Originally Posted By: mecpollett@gmail.com''' Shouldn't time('04:12:00:0000') be time('04:12:00.000') ? On Dec 6, 7:53 am, mamta bhavsar wrote: > looking for a sample code snippet to store and retrieve date and time > in SQLite database.. > as per this link, it can be stored as TEXT.. http://www.sqlite.org/datatype3.htm