jeudi 15 octobre 2015

SQLite Selecting Rows by Date

So I have a database where data which is being created gets a 'Timestamp' with it's time of creation. Now, what if I want to have all entries in the past month for example. How would I make such a call?

Here's a little snippet of a table. The timestamp is the double to the right, created by the database using OLE Automation if I'm not mistaken.

enter image description here

Any hint is appreciated.

Aucun commentaire:

Enregistrer un commentaire