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

Value in Column

php mysql unique-constraint

I am developing a small hobby application. Though I've worked with MySQL and PostgreSQL before, I'm more of a n00b here and would appreciate any help.

Extract a particular part of a large HTML code block stored in PHP variable

php dom html

I have an embeddeble code of a slide like below. this whole html is stored in a variable $embed_code.

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.