• Home
• org.opensingular
• singular-app-commons
• 1.9.0-RC1
• source code
• create-function.sql

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

db.ddl.postgres.create-function.sql Maven / Gradle / Ivy

CREATE
FUNCTION
DBSINGULAR
.
dateDiffInDays
(
DATE1
TIMESTAMP,
DATE2
TIMESTAMP
)
RETURNs
int
AS
$$
BEGIN
RETURN
DATE_PART
(
'days',
DATE1
-
DATE2
);
END;
$$
LANGUAGE
PLPGSQL;