Some Date functions for Netezza - ForumTopics.Com

Thought this might be helpful for Netezza Starters -- try these for different date calculations: SELECT date(current_Date) from dual; select add_months(current_date,-1) - date_part('day', current_date)

www.forumtopics.com