"Mark Lawrence" <breamore...@yahoo.co.uk> wrote in message news:mc1g3n$q8j$1...@ger.gmane.org... > On 18/02/2015 06:19, Frank Millman wrote: >> Hi all >> >> sqlite3 does not have a DATE type, but the python module does a pretty >> good >> job of providing one - >> >> However, the following does not return a date object - >> >>>>> cur.execute('SELECT CAST(? AS DATE)', ('2015-03-31',)) >> <sqlite3.Cursor object at 0x00FE9BE0> >>>>> cur.fetchone() >> (2015,) >>>>> >> > > Will this do? > > cur.execute('select current_date as "d [date]", current_timestamp as "ts > [timestamp]"') > row = cur.fetchone() > print("current_date", row[0], type(row[0])) > print("current_timestamp", row[1], type(row[1])) >
I will have to experiment a bit, It looks as if it will do just fine. The magic incantation is 'detect_types=sqlite3.PARSE_DECLTYPES|PARSE_COLNAMES' I had not looked at PARSE_COLNAMES before. Very useful. Thanks, Mark Frank -- https://mail.python.org/mailman/listinfo/python-list
