minutes since midnight

[ShaneBrennan]

I'm new to PHP & MySQL and I've got a little problem.

I have a time fields, start_time, in my database, which I can retrieve okay. But I want to calculate the numbers of minutes since midnight.

Any ideas how I could do this - or even better has anyone got a small useful procedure/function.

Any help will be appreciated



Shane Brennan

'-----------------------

' Emails: shanebrennan@postmaster.co.uk

 

[danielhozac]

What format is start_time? If it's a UNIX timestamp, [tt]$variable % 86400[/tt] should do it.

//Daniel

 

[danielhozac]

Actually, that would get you the number of seconds since midnight. Divide the result by 60 and you should get the right number.

//Daniel

 

[sleipnir214]

I'm actually curious as to what "minutes since midnight" means.


If I store a datetime value from today in a MySQL table, then perform the calculation tomorrow, what does "minutes since midnight" mean?

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!

 

[ShaneBrennan]

I'm trying to create a simple week planner of courses run by a college. The planner is a simple grid of :
rows of the 7 days
columns - 5 minute intervals from 8am till 10pm

Getting the number of minutes from midnight for the start and end times will let me create it. Thats it really.





Shane Brennan

'-----------------------

' Emails: shanebrennan@postmaster.co.uk

 

[skiflyer]

So, turn start time into a unix time stamp with the mktime() function and then use Daniel's suggestion, or if you prefer then use the mktime function twice, once with the timestamp you have and once with midnight of the same day/month/year.

Make sure to test your solution against daylight savings days.

-Rob