Since timestamps are integer, which are numbers, the date function can easily convert a timestamp to a date in Netezza SQL.
Date Function Arguments, per IBM Documentation
First argument data type
Second argument data type
Returns
date
numeric(8,0)
date
Example Timestamp to Date Conversion SQL
In this example CREATEDATE is stored as a timestamp, despite the field name.
SELECT
DATE(CREATEDDATE)
, COUNT(*) as CNT
FROM Blog.CASES_FS
GROUP BY
date(CREATEDDATE)
ORDER BY
date(CREATEDDATE);
Related References
Date/time functions
PureData System for Analytics, PureData System for Analytics 7.2.1, IBM Netezza database user documentation, Netezza SQL basics, Netezza SQL extensions, Date/time functions
PureData System for Analytics, PureData System for Analytics 7.2.0, IBM Netezza User-Defined Functions, Data type helper API reference, Temporal data type helper functions, Netezza date/time data type representations
