#344 Start_Time & End_Time stored as integer

[Stephen Spence]

Hi all,

I am running MRBS1.4.11 on mysql 5.6.27. MRBS itself is running brilliantly. I am trying to write a php script which pulls today's meetings through to another webpage, which I can then display on a screen in reception.

The trouble is, MRBS saves start_time and end_time as an integer in mysql. Do you know how the integer is calculated from the date time inputted by the user? I was hoping that if you did, I could then reverse it, to either get the date, or an integer which I can tag as 'today' so my script knows.

Thanks in advance for the help.

Stephen.

[Stephen Spence]

D'oh! I meant to put this is support requests. Sorry

[Campbell Morrison]

Yes, it's a Unix timestamp.