search

meeting-room-booking-system / mrbs-code

MRBS application code
Other
127 stars 63 forks source link

Convert start_time and end_time to real time #2939

Open jberanek opened 3 years ago

jberanek commented 3 years ago

Hello,

When we book a room the data is recorded on mrbs_entry table, right? Inside mrbs_entry we got start_time and end_time, if we calculate end_time - (minus) start_time, we get the duration of the booking, in seconds.

I'm building some vision on PowerBI that collect the data on our database, but I don't know how to get the Start time and End time exactly how on view_entry.php (Attachment).

start_time and end_time is the correct way? How to convert to real date? Inside mrbs_entry we got timestamp column, but this is the exactly hour that the booking was made.

In my report basicly I want: START TIME | END TIME | DURATION | CREATED BY | and some other fields that I already created.

Cheers.

Reported by: *anonymous

Original Ticket: mrbs/support-requests/2248

Attachments: https://sourceforge.net/p/mrbs/support-requests/2248/attachment/img.png

jberanek commented 3 years ago

They are Unix timestamps.

Original comment by: campbell-m

jberanek commented 3 years ago

Thank you very much!

Original comment by: *anonymous