Truncate vs delete from

Sometimes I make weird rookie mistakes when working with SQL and one of them is confusing syntax of various commands. Today it was truncate.

So the syntax is

Truncate table table_name;

It doesn't have a where clause and is used to remove the entire data. On the other hand when we use delete, the syntax can be

Delete from table_name;

It will delete the entire data, but we can also use a where clause.

Delete from table_name where column_name = criteria;

I was using truncate table table_name where date = cast(getdate() as date);

Wouldn't work and will definitely fail.

Sugandh