How to select records that updated in last 5 minutes using a last_modified_timestamp column in the table using current_date or current_timestamp function in Netezza?
Netezza get records last updated in last 5 minutes using a last modified time stamp column in the table?
859 views Asked by RAJESH At
1
If you've installed the SQL extensions, then you can use
minutes_between
.If not, you can always use intervals.