To extract data for the last month (day 1st to day 30th) from a database in DB2,
Use the below condition in WHERE clause :
TRANSDATE >= THIS_MONTH(CURRENT DATE - 1 MONTH)
AND TRANSDATE < THIS_MONTH(CURRENT DATE)
To extract data for the last month (day 1st to day 30th) from a database in DB2,
Use the below condition in WHERE clause :
TRANSDATE >= THIS_MONTH(CURRENT DATE - 1 MONTH)
AND TRANSDATE < THIS_MONTH(CURRENT DATE)
F95Zone is an online community platform that has gained significant popularity in recent years. It serves as a hub for individuals to engage in discussions share content, and connect with like-minded people. With a variety of topics and categories, F95Zone has become a go-to destination for many users seeking entertainment, information, and community interaction.
ReplyDelete