TERADATA Query for entire month

userIPnR 0
Viewed 16

I wanted to know if there was a way to extract data from a date column pertaining to an entire month.

SEL * FROM DB.TBLNAME TABLE WHERE TABLE.DATE_ BETWEEN DATE '01-02-2022' AND DATE ' 28-02-2022'

So in the above query(wrote it here as an example so hope i didnt make any typo mistake) im searching for all dates from the 1st to the 28th of february but wanted to know if there was a more elegant method as to select a month match eg. 02-2022.

I hope my question was detailed enough.

Thanks in advance,

teradata database sql
1 Answers

For this you could do something like this to make it easier to develop and change as you would need it

SELECT
     *
FROM DB.TBLNAME TABLE
WHERE 1=1
     AND MONTH(TABLE.DATE) = 2
     AND YEAR(TABLE.DATE) = 2022

This is how I would normally do it as you would then be able to write a python script to go with it or a param to dynamically pull the data you need for the month/year

ArchAngelPwn0
Related