Date Difference in MySQL to calculate age

mysql sql date datediff
chsab420 picture chsab420 · Sep 5, 2009 · Viewed 36.3k times · Source

I have a problem regarding the datediff MYSQL function, I can use it and it is simple. But I don't understand how to use it to collect differences within the table field. E.g.

I have a column dob and I want to write a query that will do something like

select dateDiff(current_timeStamp,dob) 
from sometable 'here dob is the table column

I mean I want the difference from the current date time to the table field dob, each query result is the difference, the age of the user.

Answer

Nadia Alramli picture Nadia Alramli · Sep 5, 2009

You mean like this?

SELECT DATE_FORMAT(FROM_DAYS(DATEDIFF(NOW(), dob)), "%Y")+0 AS age from sometable

(Source)

Related questions

Mysql Datediff query

I need to get the result from the table, which the date should be difference of 5 from the current date. ie., specific_date column is present in my table. The format of the date is YYYY-MM-DD. I need the query …

Read More
MySQL Query GROUP BY day / month / year

Is it possible to make a simple query to count how many records I have in a determined period of time like a year, month, or day, having a TIMESTAMP field, like: SELECT COUNT(id) FROM stats WHERE record_date.…

Read More
Difference between two dates in MySQL

How to calculate the difference between two dates, in the format YYYY-MM-DD hh: mm: ss and to get the result in seconds or milliseconds?

Read More