There is no date or datetime type in SQLite3, they are stored as TEXT usually. To use date string, you can use built-in functions here or convert text to date in Python.
Hope it helps. Regards, Xin Huang From: AMARASINGHAM, Chandra Date: 2015-06-26 10:45 To: [email protected] Subject: [melbourne-pug] sqlite3 date types Hi All, I am doing exploratory work in sqlite3. I can't seem to store dates in a table when importing from a csv. It seems to store it as a text file, even when I specify type affinity as date when creating the table. Any comments? Sorry a bit off topic, but I hope to process the sqlite3 db in python......and sqlite3 and python seem to go together. Regards, Chandra Chandra Amarasingham Analyst Programmer Specialist Diagnostic Services Pty Ltd 17 Enterprise Grove, Mt Helen, 3350 Federation University Technology Park T: (03) 5330 1056 ext 212 This email (including any attachments) is intended only for the addressee. It may contain confidential or legally privileged information. Confidentiality and privilege are not waived or lost if you are not the intended recipient of this email, nor may you use, review, disclose, disseminate or copy any information contained in or attached to it. If you receive this email in error, please delete it and any attachments from your system and notify us immediately. It is your responsibility to check this email and any attachments, before opening or using them, for viruses or defects. You assume all liability arising from opening or using this email and any attachment.
_______________________________________________ melbourne-pug mailing list [email protected] https://mail.python.org/mailman/listinfo/melbourne-pug
