mercredi 20 janvier 2016

How to query for 'task' records by date

A client wants a app that keeps his schedule. He wants a simple tableview to display a different section for each day and he wants all the tasks for that day to display in order. Here is the db schema im using:

TASK_ID , TASK_NAME, TASK_DURRATION, TASK_START_TSTAMP, TASK_END_TSTAMP,  TASK_COMPLETED

How would I begin to go about querying for tasks by day? Like if i wanted to return all the tasks for the next 7 days.

Aucun commentaire:

Enregistrer un commentaire