Hi
the point of my query is how to translate the longtext date stored in the
db to an actual date field (and visa versa). We had the custom date issue in
the older version of osticket, and our dates were not copied forward to the new
version we just upgraded to.
So, i am tasked to quickly write some code that will take
the date from another field, and place it in the custom date field in the
database
Date fields in the osticket tables are stored in a date format that is not an
issue
What is an issue is that the custom field, when date, gets
stored as a long text
so a date appears like this: 1413950400
I need to be able to convert this both ways, from and to a date.
I have been looking around, and have not been able to
(easily) find where this can be done
thanks everyone in advance