mssql vs tibero 타입/함수 비교

Mssql 과  Tibero 타입 및 함수 비교 입니다.

 

type 비교

TYPE
MS SQL	Tibero
BIGINT	NUMBER(19)
INT	NUMBER(10)
SMALLINT	NUMBER(5)
TINYINT	NUMBER(3)
DECIMAL	NUMBER(p[,s])
NUMERIC	NUMBER(p[,s])
FLOAT	FLOAT(49)
REAL	FLOAT(23)
CHAR	CHAR
NCHAR	NCHAR
NTEXT	LONG, NCLOB
NVARCHAR	NVARCHAR2
VARCHAR	VARCHAR2
TEXT	LONG, CLOB
DATETIME	DATE, TIMESTAMP
SMALLDATETIME	DATE
TIMESTAMP	TIMESTAMP
MONEY	NUMBER(19,4)
SMALLMONEY	NUMBER(10,4)
UNIQUEIDENTIFIER	CHAR(36)
IMAGE	LONG RAW
BINARY	RAW
VARBINARY	RAW
BIT	NUMBER(3)

 

숫자함수 비교

숫자함수
MSSQL	Tibero
ABS	ABS
ACOS	ACOS
ASIN	ASIN
ATAN	ATAN
ATN2	ATAN2
CEILING	CEIL
COS	COS
COT	COSH
EXP	EXP
FLOOR	FLOOR
LOG	LN
	LOG(N)
LOG10	LOG(10)
%	MOD
POWER	POWER
RAND
ROUND	ROUND
SIGN	SIGN
SIN	SIN
	SINH
SQRT	SQRT
TAN	TAN
	TANH
	TRUNC
	GREATEST
	LEAST
ISNULL	NVL

 

- 문자함수 비교

 

문자함수
MSSQL	Tibero
ASCII	ASCII
+	CONCAT or ||
CHAR	CHR
CHARINDEX	INSTR
LOWER	LOWER
UPPER	UPPER
	LPAD
LTRIM	LTRIM
RTRIM	RTRIM
PATINDEX	INSTR
REPLICATE	RPAD
SOUNDEX	SOUNDEX
SPACE	RPAD
STR or CONVERT or CAST	TO_CHAR
CONVERT or CAST
SUBSTRING	SUBSTR
REPLACE or STUFF	REPLACE
	INITCAP
	TRANSLATE
DATALENGTH or LEN	LENGTH
	GREATEST
	LEAST
ISNULL	NVL

 

- 날짜 함수 비고

날짜함수
MSSQL	Tibero
DATEADD	+
DATEDIFF	-
	LAST_DAY
	NEXT_DAY
DATENAME	TO_CHAR
DATEPART	TO_NUMBER(TO_CHAR())
CAST	TO_DATE
GETDATE()	SYSDATE