Netezza Advanced Date Functions are available in Netezza SQL extensions tool kit. You have to download it from IBM fix central and install it in required database. You cannot access these functions otherwise. Read: how to download and Install Netezza SQL extensions toolkit These advanced functions are different than standard Netezza data time functions. You can read about the standard Netezza date functions from below post: Netezza Data Functions and Examples You may want to read: nzsql command and its Usage Netezza Analytics Functions and Examples IBM Netezza Conversion Functions…