Neteza timestamp functions

30 Apr 2018

Just a quick reference of Netezza timestamp conversion functions:

  • converting epoch to a timestamp
`select '1970-01-01 00:00 GMT'::timestamp + (start_time || ' sec')::interval start_time_new, t1.*  `
  • the opposite function - convert from timestamp to epoch 
    `select extract(epoch from timestamp('01/02/2017') - timestamp('01/01/1970'));`

who am i

I am a data engineer with interests in databases, data science, algorithms and programming in general.

where am i

linkedin//rchamarthi
stackoverflow/users/237939/rchamarthi
Content available under Creative Commons (BY-NC-SA) unless otherwise noted.
This site is hosted at Github Pages and created with Jekyll. It uses the papyrus theme