SQL Reference Guide

Revision Time: 2 mins

5. Date Functions Reference

Working with dates.

CURRENT_DATE

Return: Value

Get current date.

Syntax signature:CURRENT_DATE

Code snippet:

python

SELECT * FROM orders WHERE order_date = CURRENT_DATE;

Expected Output:Today's orders.

Remember: Always ensure correct syntax formatting when calling CURRENT_DATE.

CURRENT_TIMESTAMP

Return: Value

Get current date and time.

Syntax signature:CURRENT_TIMESTAMP

Code snippet:

python

INSERT INTO logs VALUES (CURRENT_TIMESTAMP, 'Info');

Expected Output:Timestamped log insert.

Remember: Always ensure correct syntax formatting when calling CURRENT_TIMESTAMP.

DATEADD

Return: Value

Add interval offset to date.

Syntax signature:DATEADD(day, offset, date)

Code snippet:

python

SELECT DATEADD(day, 7, ship_date) FROM orders;

Expected Output:Extended shipping date.

Remember: Always ensure correct syntax formatting when calling DATEADD.

DATEDIFF

Return: Value

Subtract date differences.

Syntax signature:DATEDIFF(day, date1, date2)

Code snippet:

python

SELECT DATEDIFF(day, order_date, ship_date) FROM orders;

Expected Output:Delivery intervals in days.

Remember: Always ensure correct syntax formatting when calling DATEDIFF.

DATE_TRUNC

Return: Value

Truncate timestamp to grain.

Syntax signature:DATE_TRUNC('month', timestamp)

Code snippet:

python

SELECT DATE_TRUNC('month', join_date) FROM users;

Expected Output:Cohort month values.

Remember: Always ensure correct syntax formatting when calling DATE_TRUNC.

EXTRACT

Return: Value

Extract date part fields.

Syntax signature:EXTRACT(YEAR FROM date)

Code snippet:

python

SELECT EXTRACT(YEAR FROM join_date) FROM users;

Expected Output:Years of registrations.

Remember: Always ensure correct syntax formatting when calling EXTRACT.

Previous Topic4. String Functions Next Topic6. Number Functions