I have a question about the number of ticks.
CREATE function abc( netTicks in number )
RETURN TIMESTAMP
as
date1 DATE := '2010-11-01';
v_ticks_for_2010_11_01 NUMBER(19,0) := 634241664000000000; -- I didn't understand how this number came
v_ticks_in_a_second NUMBER(19,0) := 10000000; -- THERE ARE 10 MILLION TICKS IN A SECOND
begin
utils.dateadd('SECOND', ((netTicks - v_ticks_for_2010_11_01 )/ v_ticks_in_a_second ), date1 );-- what does this function do?
end
/
Thank you