Netezza - How to convert timestamp/datetime to 13-digit UNIX time millis?

I have read some reference about Netezza, but I cannot figure out how to convert timestamp/datetime value to 13-digit UNIX time millis.

Any suggestion or ideas?

Answers


Postgres offers the extract(epoch from . . .) function that does exactly what you want:

select extract(epoch from <datetimecol>) * 1000

This has been in Postgres for a long time, so I would guess that Netezza also supports it.


Need Your Help

Tkinter - Calling a Function With A Keybind Adds A Variable

python python-2.7 tkinter

When I call a method with a KeyBind in Tkinter, e.g. parent.bind('&lt;Return&gt;', self.login), when it calls self.login it appears to add a second variable, as if it were calling self.login(var).

Removing NSManagedObject from NSOrderedSet in UITableView

ios objective-c uitableview core-data

I have a UITableViewController that properly displays an NSOrderedSet associated with an NSManagedObject. On this UITableView, I've configured a button that enables editing and I'm able to re-order...