• 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.sqlserver.create-function.sql Maven / Gradle / Ivy

CREATE FUNCTION DBSINGULAR.TO_CHAR(@DATE_VAL DATETIME, @FORMAT VARCHAR(20)) RETURNS VARCHAR(17) AS BEGIN DECLARE @ret VARCHAR(17) IF(@FORMAT = 'DD/MM/YYYY HH24:MI') SELECT @ret = convert(varchar(10),@DATE_VAL,103) + ' ' + cast(DATEPART(HOUR,@DATE_VAL) as varchar(2)) + ':' + cast(DATEPART(MINUTE,@DATE_VAL)    as varchar(2)) ELSE IF (@FORMAT = 'dd/MM/yyyy') SELECT @ret = convert(varchar(10),@DATE_VAL,103) RETURN @ret END
--Essa função precisa ficar em apenas uma linha, se não o hibernate não consegue executar o script.