How do you suppose SQLite would know what "past_time2" and "past_time" are? To understand what I mean - Try that same code but change the execute line to: ``` c.execute('SELECT "past_time2", "past_time"') ``` Does that work as expected? (i.e. showing dates in stead of words?) If not, then try the following: Not sure what language that is (looks C#-ish but without statement terminators), so I do not know what the string concatenation character or quote-escape characters are for your language, but assuming it's "+" and doubled quotes (''), try this code: ``` c.execute('SELECT adUrl FROM donedeal_listings WHERE timestamp BETWEEN '''+past_time2+''' AND '''+past_time+'''') ``` If that doesn't help, please say what your OS, Language platform and SQLite connectors are. Good luck, Ryan