[HELP]: Get date and time of publication - 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: [HELP]: Get date and time of publication (/showthread.php?tid=662960)

---

[HELP]: Get date and time of publication - xZeDx - 17.01.2019

Hi guys, one question, I'm looking for a way to do a function, or rather, how to get the famous publication time, that is: "X minutes ago", "X hour ago", "X months ago", and successively , exists? an Include, plugin or something?
Obviously I work with MySQL
Greetings and thanks to all

---

Re: [HELP]: Get date and time of publication - andrejc999 - 17.01.2019

Publication of what?

---

Re: [HELP]: Get date and time of publication - Chyakka - 17.01.2019

While I don't quite understand what you mean by famous publication time you can use the DATEDIFF mysql function to get the number of days between two dates, you could just then format the result to say "x days ago". You could then re-interpret the number of days to work in terms of months, hours etc.

---