Posted on 2013-11-01
i've created a simple web app, for tracking the duration of time people have been signed in. it uses the unix timestamp.
i've been asked to create a daily report which a user will run the next morning which shows who signed in after a 15:15
im having trouble and cant get my brain into gear to figure this one out.
i know its going to be SELECT * from table where 'signIn' >= theTimeStamp
but i cant figure out the timestamp calculations for counting back to 15:15 everyday.
can anyone help? i hope that makes sence. if not i'll try and clarify