date - Converting Netezza timestamp to Julian Day Number -

i have been looking during days not find how do..

it like:

select to_number(to_char('2015-06-24 00:00:00','j')) on oracle.

i need find julian numeric day value, not confused ordinal date of year..

conversion templates indicate 'j' want.

i think issue have to_number() function, not to_char() function. use casts instead.

system(admin)=> select to_char('2015-06-24 00:00:00'::timestamp,'j')::int;  ?column? ----------   2457198 (1 row)