LiveCode Forums.

Hello,

Currently i have time stamps in Epoch format in my database. How do i convert it to normal date format.

Hi.

Well, I just looked up to see what "Epoch" time was.

Since that protocol starts at midnight, 1/1/1970 GMT, you are already in good shape. LC uses the same base. Watch your timezone, of course.

Craig Newman

EDIT:

Was your question how to convert the format? Look up both "seconds" and "convert" in the dictionary. Pay particular attention to the "dateItems" format, which gives great information, and you can manipulate the individual items in that string to change to a new date.

Hi Dunbarx,

Thanks. Will look into it (:

Hey BabyPrincess,

you have to
-----------------------
convert "timestamp" to dateItems
convert it from dateItems to long date and long time
-----------------------

Reg,
G

Thanks everyone.

I managed to get it working perfectly !

God bless (: