Cast timestamp to date

sql

SELECT CAST(created_at AS DATE) AS created_date
FROM orders;

Explanation

Useful for daily rollups.

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Same sheet · prioritizing Date and Time Functions

Return the current date and current timestamp.

Open In sheetsqlsame section

Return year, month, day, and other pieces from a date or timestamp.

Open In sheetsqlsame section

Shift a date or timestamp forward or backward.

Open In sheetsqlsame section

Roll up metrics by calendar day.

Open In sheetsql1 tag match

Cast an expression to a different type.

Open In sheetsql1 tag match

Join multiple strings into one value.