 Does anyone know the database format of the Event date fields? It appears these are stored in table: bx_events_main as columns: Date, EventStart, EventEnd These are defined as int(11) but format of the values stored in these columns is unclear, e.g., 1457717400 is 2016-03-11 17:30. Would like to read and potentially update these dates via database backend. Thanks! |
what you see is a timestamp representation of each second starting (i forget when) of the proposed time. The date function is used to translate this into whatever format you want - in this case, year-month-day format. You can use this calculator to convert manually http://www.epochconverter.com/ caredesign.net |
what you see is a timestamp representation of each second starting (i forget when) of the proposed time. The date function is used to translate this into whatever format you want - in this case, year-month-day format. You can use this calculator to convert manually http://www.epochconverter.com/ Thanks very much for sharing this! |
