Don't have Telegram yet? Try it now!
https://scientiacompendium.com/2017/05/03/netezza-puredata-how-to-convert-a-timestamp-to-date-in-sql/
Netezza / PureData – How to convert a timestamp to date in SQL