How to use 'between' operator for dates in teradata?

@kadin 

To use the 'BETWEEN' operator for dates in Teradata, you can follow the syntax below:

SELECT * FROM table_name WHERE date_column BETWEEN start_date AND end_date;

In this syntax:

• 'table_name' is the name of the table you are querying.
• 'date_column' is the name of the column containing dates in the table.
• 'start_date' and 'end_date' should be replaced with the specific dates you want to filter between.

For example, if you want to retrieve all records where the date is between '2021-01-01' and '2021-12-31', you can write the query as:

SELECT * FROM table_name WHERE date_column BETWEEN date '2021-01-01' AND date '2021-12-31';