How do I query timestamps in SQL?

How do I query timestamps in SQL?

You can query timestamps in SQL using the WHERE clause. For example, to find records from a specific date, you can use: SELECT * FROM table_name WHERE timestamp_column = '2023-10-01';

What if I want to get records from the last 30 days?

You can use the NOW() function along with INTERVAL. For example: SELECT * FROM table_name WHERE timestamp_column >= NOW() - INTERVAL 30 DAY;

How can I format the timestamp in the result?

You can use the DATE_FORMAT() function. For example: SELECT DATE_FORMAT(timestamp_column, '%Y-%m-%d %H:%i:%s') FROM table_name;

Can I group records by date?

Yes, you can group records by date using the GROUP BY clause. For example: SELECT DATE(timestamp_column) AS date, COUNT(*) FROM table_name GROUP BY DATE(timestamp_column);