MySQL (BlueG) Subtract 2 Dates
#1

MySQL (BlueG) Subtract 2 Dates

Hello,
In the DataBase I storing registration date in DateTime field.
I want to check the amount of days passed from registration, simply Subtract 2 Dates.

What the type of variable I must to use to do this one?

Thanks!
Reply
#2

Use an INT field type and store a timestamp (using gettime() in PAWN). There are functions around here that can take two timestamps and determine how many days are between them...
Reply
#3

Quote:
Originally Posted by RealCop228
Посмотреть сообщение
Use an INT field type and store a timestamp (using gettime() in PAWN). There are functions around here that can take two timestamps and determine how many days are between them...
Can you give me the functions?
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)