Accessing datetime field in sqlite using python-django

Question

I have a SQLite DB which has few columns of type datetime. These column store time (just the time and not the date) in HH:mm:ss format. When I try to access this field it is returned as null. In models.py this field have been mapped to equivalent models.DateTimeField.

What is the correct way of accessing such fields? Is it required that models.DateTimeField HAS TO BE stored in YYYY-MM-DD HH:mm:ss format insqlite?

score 2 · Answer 1 · answered Apr 03 '13 at 07:05

2

I am not suprised that DateTimeField expects both a date and a time.

Try TimeField instead.

(Please note that SQLite does not have a native date/time type; it's just a string.)

answered Apr 03 '13 at 07:05

CL.

173,858
17
217
259

Accessing datetime field in sqlite using python-django

1 Answers1