public final class Functions extends Object
Modifier and Type | Method and Description |
---|---|
static Integer |
asc(String s) |
static double |
atn(double v) |
static boolean |
cbool(BigDecimal value) |
static boolean |
cbool(Boolean value) |
static boolean |
cbool(String value) |
static BigDecimal |
ccur(BigDecimal value) |
static Timestamp |
cdate(String dt) |
static Double |
cdbl(Double value) |
static Double |
cdec(Double value) |
static Short |
cint(boolean value) |
static Short |
cint(Double value) |
static Integer |
clng(Double value) |
static Integer |
clng(Integer value) |
static Integer |
clng(String value) |
static Integer |
clong(boolean value) |
static Integer |
clong(Double value) |
static Integer |
clong(Integer value) |
static Boolean |
contains(Object obj1,
Object obj2) |
static double |
csign(double value) |
static String |
cstr(Boolean value) |
static String |
cstr(double value) |
static String |
cstr(int value) |
static String |
cstr(Object value) |
static String |
cstr(String value) |
static String |
cstr(Timestamp value) |
static String |
cvar(Double value) |
static Timestamp |
date() |
static Date |
dateAdd(String intv,
int vl,
Date dt) |
static Timestamp |
dateAdd(String intv,
int vl,
String dt) |
static Timestamp |
dateAdd(String intv,
int vl,
Timestamp dt) |
static Integer |
dateDiff(String intv,
String dt1,
String dt2) |
static Integer |
dateDiff(String intv,
String dt1,
Timestamp dt2) |
static Integer |
dateDiff(String intv,
Timestamp dt1,
String dt2) |
static Integer |
dateDiff(String intv,
Timestamp dt1,
Timestamp dt2) |
static Integer |
datePart(String intv,
String dt) |
static Integer |
datePart(String intv,
String dt,
Integer firstDayOfWeek) |
static Integer |
datePart(String intv,
String dt,
Integer firstDayOfWeek,
Integer firstWeekOfYear) |
static Integer |
datePart(String intv,
Timestamp dt) |
static Integer |
datePart(String intv,
Timestamp dt,
Integer firstDayOfWeek) |
static Integer |
datePart(String intv,
Timestamp dt,
Integer firstDayOfWeek,
Integer firstWeekOfYear) |
static Timestamp |
dateSerial(int year,
int month,
int day) |
static Timestamp |
dateValue(String dt) |
static Timestamp |
dateValue(Timestamp dt) |
static double |
ddb(double cost,
double salvage,
double life,
double period) |
static double |
ddb(double cost,
double salvage,
double life,
double period,
double factor) |
static Boolean |
equals(Object obj1,
Object obj2) |
static Boolean |
equalsIgnoreOrder(Object obj1,
Object obj2) |
static double |
fix(double d) |
static String |
format(double d,
String par) |
static String |
format(String s,
String par) |
static String |
format(String s,
String par,
boolean incl) |
static String |
format(Timestamp t,
String par) |
static Boolean |
formulaToBoolean(Boolean res,
String datatype) |
static Boolean |
formulaToBoolean(Double res,
String datatype) |
static Boolean |
formulaToBoolean(String res,
String datatype) |
static Boolean |
formulaToBoolean(Timestamp res,
String datatype) |
static Timestamp |
formulaToDate(Boolean res,
String datatype) |
static Timestamp |
formulaToDate(Double res,
String datatype) |
static Timestamp |
formulaToDate(String res,
String datatype) |
static Timestamp |
formulaToDate(Timestamp res,
String datatype) |
static Double |
formulaToNumeric(Boolean res,
String datatype) |
static Double |
formulaToNumeric(Double res,
String datatype) |
static Double |
formulaToNumeric(String res,
String datatype) |
static Double |
formulaToNumeric(Timestamp res,
String datatype) |
static String |
formulaToText(Boolean res,
String datatype) |
static String |
formulaToText(Double res,
String datatype) |
static String |
formulaToText(String res,
String datatype) |
static String |
formulaToText(Timestamp res,
String datatype) |
static double |
fv(double rate,
int periods,
double payment) |
static double |
fv(double rate,
int periods,
double payment,
double pv) |
static double |
fv(double rate,
int periods,
double payment,
double pv,
double type) |
static Boolean |
iif(Boolean b,
Boolean o,
Boolean o1) |
static Double |
iif(Boolean b,
Double o,
Double o1) |
static Integer |
iif(Boolean b,
Integer o,
Integer o1) |
static String |
iif(Boolean b,
String o,
String o1) |
static Timestamp |
iif(Boolean b,
Timestamp o,
Timestamp o1) |
static Integer |
instr(Integer start,
String text,
String search) |
static Integer |
instr(Integer start,
String text,
String search,
Integer compare) |
static Integer |
instr(String text,
String search) |
static Integer |
instr(String text,
String search,
Integer compare) |
static Integer |
instrrev(String text,
String search) |
static Integer |
instrrev(String text,
String search,
Integer start) |
static Integer |
instrrev(String text,
String search,
Integer start,
Integer compare) |
static double |
ipmt(double rate,
double per,
double nper,
double pv) |
static double |
ipmt(double rate,
double per,
double nper,
double pv,
double fv) |
static double |
ipmt(double rate,
double per,
double nper,
double pv,
double fv,
double type) |
static boolean |
isDate(String dt) |
static boolean |
isDate(Timestamp dt) |
static boolean |
isNull(Double o) |
static boolean |
isNull(String o) |
static boolean |
isNull(Timestamp o) |
static boolean |
isNumeric(BigDecimal b) |
static boolean |
isNumeric(String s) |
static String |
left(String input,
int i) |
static String |
leftS(String input,
int i) |
static Integer |
len(String o) |
static String |
mid(String value,
int start) |
static String |
mid(String value,
int start,
int length) |
static Short |
mint(boolean value) |
static Integer |
mint(Double value) |
static String |
monthName(int i) |
static String |
monthName(int i,
boolean abbr) |
static Timestamp |
now() |
static double |
nper(double rate,
double pmt,
double pv) |
static double |
nper(double rate,
double pmt,
double pv,
double fv) |
static double |
nper(double rate,
double pmt,
double pv,
double fv,
double type) |
static BigDecimal |
nz(BigDecimal value) |
static BigDecimal |
nz(BigDecimal value,
BigDecimal outher) |
static Double |
nz(Double value) |
static Double |
nz(Double value,
Double outher) |
static Integer |
nz(Integer value) |
static Integer |
nz(Integer value,
Integer outher) |
static String |
nz(String value) |
static String |
nz(String value,
String outher) |
static String |
orderJet(String s) |
static String |
partition(Double number,
double start,
double stop,
double interval) |
static double |
pmt(double rate,
double periods,
double pv) |
static double |
pmt(double rate,
double periods,
double pv,
double fv) |
static double |
pmt(double rate,
double periods,
double pv,
double fv,
double type) |
static double |
ppmt(double rate,
int per,
int nper,
double pv) |
static double |
ppmt(double rate,
int per,
int nper,
double pv,
double fv) |
static double |
ppmt(double rate,
int per,
int nper,
double pv,
double fv,
double type) |
static double |
pv(double rate,
double nper,
double pmt) |
static double |
pv(double rate,
double nper,
double pmt,
double fv) |
static double |
pv(double rate,
double nper,
double pmt,
double fv,
double type) |
static double |
rate(double nper,
double pmt,
double pv) |
static double |
rate(double nper,
double pmt,
double pv,
double fv) |
static double |
rate(double nper,
double pmt,
double pv,
double fv,
double type) |
static double |
rate(double nper,
double pmt,
double pv,
double fv,
double type,
double guess) |
static String |
right(String input,
int i) |
static String |
rightS(String input,
int i) |
static Double |
rnd() |
static Double |
rnd(Double d) |
static double |
round(double d,
double p) |
static short |
sign(double n) |
static double |
sln(double cost,
double salvage,
double life) |
static String |
space(Integer nr) |
static double |
sqr(double v) |
static String |
str(double d) |
static Integer |
strComp(String value1,
String value2) |
static Integer |
strComp(String value1,
String value2,
Integer type) |
static String |
strConv(String value,
int ul) |
static String |
string(Integer nr,
String str) |
static String |
strReverse(String value) |
static double |
syd(double cost,
double salvage,
double life,
double per) |
static Timestamp |
time() |
static Timestamp |
timeserial(Integer h,
Integer m,
Integer s) |
static Timestamp |
timestamp0(String dt) |
static Double |
val(BigDecimal val1) |
static Double |
val(String val1) |
static Integer |
weekDay(Timestamp dt) |
static Integer |
weekDay(Timestamp dt,
Integer firstDayOfWeek) |
static String |
weekDayName(int i) |
static String |
weekDayName(int i,
boolean abbr) |
static String |
weekDayName(int i,
boolean abbr,
int s) |
public static double atn(double v)
public static double sqr(double v)
public static boolean cbool(BigDecimal value)
public static boolean cbool(Boolean value)
public static boolean cbool(String value)
public static BigDecimal ccur(BigDecimal value) throws UcanaccessSQLException
UcanaccessSQLException
public static Double cdbl(Double value) throws UcanaccessSQLException
UcanaccessSQLException
public static Double cdec(Double value) throws UcanaccessSQLException
UcanaccessSQLException
public static Short cint(Double value) throws UcanaccessSQLException
UcanaccessSQLException
public static Short cint(boolean value) throws UcanaccessSQLException
UcanaccessSQLException
public static Integer clong(Double value) throws UcanaccessSQLException
UcanaccessSQLException
public static Integer clong(Integer value) throws UcanaccessSQLException
UcanaccessSQLException
public static Integer clng(Double value) throws UcanaccessSQLException
UcanaccessSQLException
public static Integer clng(String value) throws UcanaccessSQLException
UcanaccessSQLException
public static Integer clng(Integer value) throws UcanaccessSQLException
UcanaccessSQLException
public static Integer clong(boolean value) throws UcanaccessSQLException
UcanaccessSQLException
public static double csign(double value)
public static String cstr(Boolean value) throws UcanaccessSQLException
UcanaccessSQLException
public static String cstr(String value) throws UcanaccessSQLException
UcanaccessSQLException
public static String cstr(double value) throws UcanaccessSQLException
UcanaccessSQLException
public static String cstr(int value) throws UcanaccessSQLException
UcanaccessSQLException
public static String cstr(Object value) throws UcanaccessSQLException
UcanaccessSQLException
public static String cstr(Timestamp value) throws UcanaccessSQLException
UcanaccessSQLException
public static String cvar(Double value) throws UcanaccessSQLException
UcanaccessSQLException
public static Date dateAdd(String intv, int vl, Date dt) throws UcanaccessSQLException
UcanaccessSQLException
public static Timestamp dateAdd(String intv, int vl, Timestamp dt) throws UcanaccessSQLException
UcanaccessSQLException
public static Timestamp dateAdd(String intv, int vl, String dt) throws UcanaccessSQLException
UcanaccessSQLException
public static Integer dateDiff(String intv, String dt1, String dt2) throws UcanaccessSQLException
UcanaccessSQLException
public static Integer dateDiff(String intv, String dt1, Timestamp dt2) throws UcanaccessSQLException
UcanaccessSQLException
public static Integer dateDiff(String intv, Timestamp dt1, String dt2) throws UcanaccessSQLException
UcanaccessSQLException
public static Integer dateDiff(String intv, Timestamp dt1, Timestamp dt2) throws UcanaccessSQLException
UcanaccessSQLException
public static Integer datePart(String intv, String dt, Integer firstDayOfWeek) throws UcanaccessSQLException
UcanaccessSQLException
public static Integer datePart(String intv, Timestamp dt, Integer firstDayOfWeek) throws UcanaccessSQLException
UcanaccessSQLException
public static Integer datePart(String intv, String dt, Integer firstDayOfWeek, Integer firstWeekOfYear) throws UcanaccessSQLException
UcanaccessSQLException
public static Integer datePart(String intv, Timestamp dt, Integer firstDayOfWeek, Integer firstWeekOfYear) throws UcanaccessSQLException
UcanaccessSQLException
public static Integer datePart(String intv, String dt) throws UcanaccessSQLException
UcanaccessSQLException
public static Integer datePart(String intv, Timestamp dt) throws UcanaccessSQLException
UcanaccessSQLException
public static Timestamp dateSerial(int year, int month, int day)
public static String format(double d, String par) throws UcanaccessSQLException
UcanaccessSQLException
public static String format(String s, String par) throws UcanaccessSQLException
UcanaccessSQLException
public static String format(String s, String par, boolean incl) throws UcanaccessSQLException
UcanaccessSQLException
public static String format(Timestamp t, String par) throws UcanaccessSQLException
UcanaccessSQLException
public static boolean isDate(String dt)
public static boolean isDate(Timestamp dt)
public static boolean isNull(String o)
public static boolean isNull(Timestamp o)
public static boolean isNull(Double o)
public static boolean isNumeric(BigDecimal b)
public static boolean isNumeric(String s)
public static String monthName(int i) throws UcanaccessSQLException
UcanaccessSQLException
public static String monthName(int i, boolean abbr) throws UcanaccessSQLException
UcanaccessSQLException
public static Timestamp date()
public static Timestamp now()
public static BigDecimal nz(BigDecimal value)
public static short sign(double n)
public static String str(double d)
public static Timestamp time()
public static Double val(BigDecimal val1)
public static String weekDayName(int i)
public static String weekDayName(int i, boolean abbr)
public static String weekDayName(int i, boolean abbr, int s)
public static Integer weekDay(Timestamp dt) throws UcanaccessSQLException
UcanaccessSQLException
public static Integer weekDay(Timestamp dt, Integer firstDayOfWeek) throws UcanaccessSQLException
UcanaccessSQLException
public static String string(Integer nr, String str) throws UcanaccessSQLException
UcanaccessSQLException
public static Double rnd()
public static BigDecimal nz(BigDecimal value, BigDecimal outher)
public static Integer strComp(String value1, String value2, Integer type) throws UcanaccessSQLException
UcanaccessSQLException
public static Integer strComp(String value1, String value2) throws UcanaccessSQLException
UcanaccessSQLException
public static Integer mint(Double value) throws UcanaccessSQLException
UcanaccessSQLException
public static Short mint(boolean value) throws UcanaccessSQLException
UcanaccessSQLException
public static double ddb(double cost, double salvage, double life, double period)
public static double ddb(double cost, double salvage, double life, double period, double factor)
public static double fv(double rate, int periods, double payment)
public static double fv(double rate, int periods, double payment, double pv)
public static double fv(double rate, int periods, double payment, double pv, double type)
public static double pmt(double rate, double periods, double pv)
public static double pmt(double rate, double periods, double pv, double fv)
public static double pmt(double rate, double periods, double pv, double fv, double type)
public static double nper(double rate, double pmt, double pv)
public static double nper(double rate, double pmt, double pv, double fv)
public static double nper(double rate, double pmt, double pv, double fv, double type)
public static double ipmt(double rate, double per, double nper, double pv)
public static double ipmt(double rate, double per, double nper, double pv, double fv)
public static double ipmt(double rate, double per, double nper, double pv, double fv, double type)
public static double pv(double rate, double nper, double pmt)
public static double pv(double rate, double nper, double pmt, double fv)
public static double pv(double rate, double nper, double pmt, double fv, double type)
public static double ppmt(double rate, int per, int nper, double pv)
public static double ppmt(double rate, int per, int nper, double pv, double fv)
public static double ppmt(double rate, int per, int nper, double pv, double fv, double type)
public static double sln(double cost, double salvage, double life)
public static double syd(double cost, double salvage, double life, double per)
public static double rate(double nper, double pmt, double pv)
public static double rate(double nper, double pmt, double pv, double fv)
public static double rate(double nper, double pmt, double pv, double fv, double type)
public static double rate(double nper, double pmt, double pv, double fv, double type, double guess)
public static Double formulaToNumeric(Timestamp res, String datatype) throws UcanaccessSQLException
UcanaccessSQLException
public static String formulaToText(Double res, String datatype) throws UcanaccessSQLException
UcanaccessSQLException
public static String formulaToText(Boolean res, String datatype) throws UcanaccessSQLException
UcanaccessSQLException
public static String formulaToText(Timestamp res, String datatype) throws UcanaccessSQLException
UcanaccessSQLException
public static Timestamp formulaToDate(Boolean res, String datatype) throws UcanaccessSQLException
UcanaccessSQLException
public static Timestamp formulaToDate(Double res, String datatype) throws UcanaccessSQLException
UcanaccessSQLException
public static double round(double d, double p)
public static double fix(double d) throws UcanaccessSQLException
UcanaccessSQLException
public static String partition(Double number, double start, double stop, double interval) throws UcanaccessSQLException
UcanaccessSQLException
Copyright © 2012–2018 UCanAccess. All rights reserved.