query Archives - Ubiq BI

How to calculate age from date of birth in SQL

Here’s how to calculate age from date of birth in SQL you can use the following MySQL query. This is useful to find out recency of activity.

Calculating difference between two dates in MySQL is really easy. Here’s how you can do it. Let’s say dt1 and dt2 are 2 columns in table table_name.

Here’s how to get MySQL database size for all or a specific database. You can use the following SQL query to get it.