Days with datetime MySQL and MTA or Lua function

[aka Blue]

Hi everyone! I have a little question about datetime function

I use a MySQL database and I want to know the number of days that have passed.

The format of datetime is: YYYY/MM/DD HH/MM/SS

Is there any function to subtract the days and know how many have passed? In MTA or Lua because I know that exists datediff but i don't want to query all the time

Thanks in advance!

[Pirulax]

I'd store a simple timestamp, then use getRealTime(timestamp), and there you go

[aka Blue]

9 hours ago, Pirulax said:

I'd store a simple timestamp, then use getRealTime(timestamp), and there you go

Thanks for answering! Finally I used timestamp but I would like to know how to format the value to receive a date, like...

Timestamp = 15351823012

Function that returns = 12-01-2018...

¿It is possible?

Thanks in advance!

[aka Blue]

Fixed. The os.date function was the solution