Hello,I am trying to export a date from the osticket DB.I created a form with date and time field.I created a ticket using this form and I fill in it with the following date "09/27/2014"I checked in my DB and the value according to this date in the table ost_form_entry_values is "1411768800"Could someone explain me how it is converted and what I have to do in order to obtain the original value after my SQL request.
convert it from unix datetime format to real time?This thread may assist: http://stackoverflow.com/questions/136782/convert-from-mysql-datetime-to-another-format-with-php
Hello,Thanks for your answer.For people who will make the same research, I write below the function I used in my php code.$date = date('Y-m-d', timestampunix);For instance, my timestamp unix was stored in a variable named "ticketcreated"To obtain the date format I want in another variable named "thedate" I used:$thedate = date('Y-m-d', $ticketcreated);The date format you can obtain are defined there: PHP date()
