Translations:Documentation/HowTo/MigrateFromHSQLDB/40/sl

From The Document Foundation Wiki
Jump to: navigation, search
Številske
HSQLDB HSQLDB in Firebird Firebird
BITAND(a,b) BIN_AND(a,b)
BITOR(a,b) BIN_OR(a,b)
BITXOR(a,b) BIN_XOR(a,b)
DEGREES(d) <value for radians>*360/(2*PI())
LOG(d) LN(d)
RADIANS(d) <value for degrees>*2*PI()/360
ROUNDMAGIC(d) Ni funkcije
TRUNCATE(a,b) TRUNC(a,b)
Besedilne
HSQLDB HSQLDB in Firebird Firebird
ASCII(s) ASCII_VAL(s)
BIT_LENGTH(s) Vrne dolžino besedila. HSQLDB: 16 bitov na znak Firebird: 8 bitov, posebni znaki 16 bitov. Isto ime, drugačno štetje! BIT_LENGTH(s)
CHAR(c) ASCII_CHAR(c)
CONCAT(str1,str2)

'str1'+'str2'+'str3'

'str1'‖'str2'‖'str3'
DIFFERENCE(s1,s2) Ni funkcije
HEXTORAW(s) Ni funkcije
INSERT(s1,start,len,s2) OVERLAY(s1 PLACING s2 FROM start [FOR len])

Ne deluje v up. vmesniku za poizvedbe

LCASE(s) LOWER(s)
LENGTH(s) CHAR_LENGTH(s)

CHARACTER_LENGTH()

LOCATE(search,s[,start]) POSITION(search IN s) POSITION(search,s[,start])
LTRIM(s) TRIM(LEADING FROM s)
OCTET_LENGTH(s) Isto ime, drugačno štetje!
RAWTOHEX(s) Ni funkcije
REPEAT(s,count) Ni funkcije
RTRIM(s) TRIM(TRAILING FROM s)
SOUNDEX(s) Ni funkcije
SPACE(count) Ni funkcije
SUBSTR(s,start[,len])

SUBSTRING(s,start[,len])

SUBSTRING(s FROM start [ FOR len])
UCASE(s) UPPER(s)
Datum/čas
HSQLDB HSQLDB in Firebird Firebird
CURDATE() CURRENT_DATE
CURTIME() CURRENT_TIME
DATEDIFF(string, datetime1, datetime2)'ms'='millisecond', 'ss'='second', 'mi'='minute', 'hh'='hour', 'dd'='day', 'mm'='month', 'yy' = 'year' DATEDIFF(string, datetime1, datetime2) millisecond, second, minute, hour, day, week, month, year

Le dolga različica brez

DAY(date)DAYOFMONTH(date) EXTRACT(DAY FROM datetime)
DAYNAME(date) Ni funkcije
DAYOFWEEK(date) EXTRACT(WEEKDAY FROM datetime)

Ne deluje v up. vmesniku za poizvedbe

DAYOFYEAR(date) EXTRACT(YEARDAY FROM datetime)

Ne deluje v up. vmesniku za poizvedbe

HOUR(time) EXTRACT(HOUR FROM datetime)
MINUTE(time) EXTRACT(MINUTE FROM datetime)
MONTH(date) EXTRACT(MONTH FROM datetime)
MONTHNAME(date) Ni funkcije
NOW() CURRENT_TIMESTAMP
QUARTER(date) CEILING(EXTRACT(MONTH FROM date)/3.00)
SECOND(time) EXTRACT(SECOND FROM datetime)
WEEK(date) EXTRACT(WEEK FROM datetime)

Ne deluje v up. vmesniku za poizvedbe

YEAR(date) EXTRACT(YEAR FROM datetime)
TO_CHAR(datetime, string) Ni funkcije
Povezovanje z zbirko podatkov
HSQLDB HSQLDB in Firebird Firebird
DATABASE() RDB$GET_CONTEXT('SYSTEM', 'DB_NAME')

Ne deluje v up. vmesniku za poizvedbe

USER()

Ne deluje v up. vmesniku za poizvedbe

CURRENT_USER
IDENTITY() Ni funkcije
Sistem
HSQLDB HSQLDB in Firebird Firebird
IFNULL(exp,value) COALESCE(expr1,expr2,expr3,...)
CASEWHEN(exp,v1,v2) CASE WHEN expr1 THEN v1[WHEN expr2 THEN v2] [ELSE v4] END IIF(exp,v1,v2)(samo ko je CASE WHEN preveč zapleten)
CONVERT(term,type) CAST(term AS type)