10Jul/130
Get First Day of Month and First Day of Last Month in Teradata
First day of last month:
select ADD_MONTHS( CURRENT_DATE - EXTRACT( DAY FROM CURRENT_DATE ) + 1,-1) |
First day of current month:
select CURRENT_DATE - EXTRACT( DAY FROM CURRENT_DATE ) + 1 |