Re: Milliseconds Timestamps

I wanted to create a stored function for this. But what type do i have to use for an interval in a function. With a little workaround it works.

CREATE OR REPLACE VIEW AAAA
(A)
AS
SELECT SYSTIMESTAMP-SYSTIMESTAMP A FROM DUAL
/

CREATE OR REPLACE FUNCTION Interval_Secs2(

	p_date_a    	      AAAA.A%TYPE, --INTERVAL ????
	p_precision           NUMBER := 0

    RETURN NUMBER
IS

BEGIN
    RETURN ROUND(EXTRACT(SECOND FROM p_date_a ),p_precision) +

	         EXTRACT(MINUTE FROM p_date_a ) * 60 +
			 EXTRACT(HOUR   FROM p_date_a ) * 3600 +
			 EXTRACT(DAY    FROM p_date_a ) * 86400;

END Interval_Secs2;
/

But is there another way to do it without the view?

Björn Received on Thu Jan 26 2006 - 10:12:43 CST