Hi Does anyone know how to convert an integer (currently in an sqlite DB) into a meaningful date using PHP. An example of the date is '2455217' or '2455231', I have spent three days tring to find a solution but just cannot figure it out and nothing in the forums. Any help would be appreciated. Thanks in advance.
Trouble is the dates dont come out right, they all come out as 29-01-1970 when I know that 2455217=20 Jan 2010 and 2455241=13 Feb 2010. Is there some special formula you are meant to use.
This will give you an idea to solve your problem http://old.nabble.com/datetime-as-integer-td22490623.html