Datetime Stamps SQL - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: Datetime Stamps SQL (/showthread.php?tid=435387)

---

Datetime Stamps SQL - nielsbon1 - 06.05.2013

Hey guys,

I am making a gamemode in SQL and i want to save + read the SQL datetime stamps. I only have no idea how to do this because when i do mysql_get_field on the datetime stamp i get nothing in return. Does anyone know a solution for this to do this fast? The solution also needs to work with PHP.

---

Re: Datetime Stamps SQL - Vince - 06.05.2013

Use unix timestamps. These are just integers and can be saved as such. To get a readable date use MySQL's FROM_UNIXTIME function.

http://dev.mysql.com/doc/refman/5.0/..._from-unixtime

---