core-jgi/db/postgresql/functions/getDate.sql

CREATE OR REPLACE FUNCTION getDate()
RETURNS TIMESTAMP WITH TIME ZONE AS $$
BEGIN
    RETURN statement_timestamp();
END;
$$ LANGUAGE plpgsql STABLE;
dos2unix on pl/pgsql functions Add BOM_Qty_AvailableASI, nextIDFunc 2008-11-01 09:07:34 +07:00			`CREATE OR REPLACE FUNCTION getDate()`
			`RETURNS TIMESTAMP WITH TIME ZONE AS $$`
			`BEGIN`
IDEMPIERE-4177 Replace SYSDATE with getDate() 2020-03-03 09:07:14 +07:00			`RETURN statement_timestamp();`
dos2unix on pl/pgsql functions Add BOM_Qty_AvailableASI, nextIDFunc 2008-11-01 09:07:34 +07:00			`END;`
IDEMPIERE-4177 Replace SYSDATE with getDate() 2020-03-03 09:07:14 +07:00			`$$ LANGUAGE plpgsql STABLE;`