Translations:Documentation/HowTo/MigrateFromHSQLDB/40/sl
Š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) |