Package net.ucanaccess.converters

Class Functions

java.lang.Object

net.ucanaccess.converters.Functions

public final class Functions
extends Object

Method Summary

Modifier and Type	Method	Description
static Integer	asc(String _s)	Returns an Integer representing the character code corresponding to the first letter in a string.
static double	atn(double _number)	Returns a double specifying the arctangent of a number.
static boolean	cbool(Boolean _value)	Converts a value to a boolean.
static boolean	cbool(String _value)
static boolean	cbool(BigDecimal _value)
static BigDecimal	ccur(BigDecimal _value)	Converts an expression into a currency value.
static Timestamp	cdate(String _dt)	Converts an expression into a date value.
static Double	cdbl(Double _number)	Converts an expression to a double.
static Double	cdec(Double _number)
static Short	cint(boolean _boolean)
static Short	cint(Double _number)
static Integer	clng(Double _value)	Converts an expression to a long integer.
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(double _value)
static String	cstr(int _value)
static String	cstr(Boolean _value)	Converts a value to a string.
static String	cstr(String _value)
static String	cstr(Timestamp _value)
static String	cvar(Double _value)
static Timestamp	date()	Returns the current system date.
static Timestamp	dateAdd(String _intv, int _vl, String _dt)
static Timestamp	dateAdd(String _intv, int _vl, Timestamp _dt)
static Date	dateAdd(String _intv, int _vl, Date _dt)	Returns a date containing a date to which a specified time interval has been added.
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 _interval, Timestamp _date, Integer _firstDayOfWeek)	Returns an integer containing the specified part of a given date.
static Integer	datePart(String _intv, Timestamp _dt, Integer _firstDayOfWeek, Integer _firstWeekOfYear)
static Timestamp	dateSerial(int _year, int _month, int _day)	Returns a date for a specified year, month, and day.
static Timestamp	dateValue(String _dt)
static Timestamp	dateValue(Timestamp _dt)	Returns a date based on a string.
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 _number)	Returns the integer portion of a number.
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 _o1, Boolean _o2)
static Double	iif(Boolean _b, Double _o1, Double _o2)
static Integer	iif(Boolean _b, Integer _o1, Integer _o2)
static String	iif(Boolean _b, String _o1, String _o2)	Returns one of two parts, depending on the evaluation of an expression.
static Timestamp	iif(Boolean b, Timestamp _o1, Timestamp _o2)
static Integer	instr(Integer _start, String _text, String _search)	Returns the position of the first occurrence of a string in another string.
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)	Returns the position of the first occurrence of a string in another string, starting from the end of the string.
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 _value)	Returns true if the expression is a valid date, otherwise false.
static boolean	isDate(Timestamp _value)
static boolean	isNull(Double _value)
static boolean	isNull(String _value)	Returns true if the expression is a null value, otherwise false.
static boolean	isNull(Timestamp _value)
static boolean	isNumeric(String _s)
static boolean	isNumeric(BigDecimal b)	Returns true if the expression is a valid number, otherwise false.
static String	left(String _input, int _i)	Extracts a substring from a string, starting from the left-most character.
static String	leftS(String input, int i)
static Integer	len(String _value)	Returns the length of the specified string.
static String	mid(String _value, int start)	Extracts a substring from a string (starting at any position).
static String	mid(String _value, int start, int length)
static Short	mint(boolean _value)
static Integer	mint(Double _value)	Returns the integer portion of a number.
static String	monthName(int _number)	Returns a string representing the month given a number from 1 to 12.
static String	monthName(int _number, boolean _abbreviate)
static Timestamp	now()	Returns the current system date and time.
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 Double	nz(Double _value)
static Double	nz(Double value, Double _other)
static Integer	nz(Integer _value)
static Integer	nz(Integer value, Integer _other)
static String	nz(String _value)	Returns the second argument if the first argument is null.
static String	nz(String _value, String _other)
static BigDecimal	nz(BigDecimal _value)
static BigDecimal	nz(BigDecimal value, BigDecimal _other)
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)	Extracts a substring from a string starting from the right-most character.
static String	rightS(String input, int i)
static Double	rnd()	Generates a random number (integer value).
static Double	rnd(Double _d)
static double	round(double d, double p)	Returns a number rounded to a specified number of decimal places.
static short	sgn(double _n)	Returns the sign of a number.
static short	sign(double _n)
static double	sln(double cost, double salvage, double life)
static String	space(Integer _nr)	Returns a string with a specified number of spaces.
static double	sqr(double _number)	Returns a double specifying the square root of a number.
static String	str(double d)	Returns a string representation of a number.
static Integer	strComp(String _value1, String _value2)
static Integer	strComp(String _value1, String _value2, Integer _type)	Returns an integer value representing the result of a string comparison.
static String	strConv(String _value, int _conversion)	Returns a string converted as specified.
static String	string(Integer _nr, String _str)	Returns a Variant (String) containing a repeating character string of the length specified.
static String	strReverse(String _value)	Returns a string whose characters are in reverse order.
static double	syd(double cost, double salvage, double life, double per)
static Timestamp	time()	Returns the current system time.
static Timestamp	timeSerial(Integer _h, Integer _m, Integer _s)	Returns a time given an hour, minute, and second value.
static Timestamp	timestamp0(String _dt)
static Double	val(String _val1)	Accepts a string as input and returns the numbers found in that string.
static Double	val(BigDecimal _val1)
static Integer	weekDay(Timestamp _date)	Returns a number representing the day of the week (a number from 1 to 7) given a date value.
static Integer	weekDay(Timestamp _date, Integer _firstDayOfWeek)
static String	weekdayName(int _number)	Returns a string representing the day of the week given a number from 1 to 7.
static String	weekdayName(int _number, boolean _abbreviate)
static String	weekdayName(int _number, boolean _abbreviate, int _firstDayOfWeek)

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Method Details

asc

public static Integer asc(String _s)

Returns an Integer representing the character code corresponding to the first letter in a string.

Parameters:

_s - any valid string expression

Returns:

character code

equals

public static Boolean equals(Object _obj1,
 Object _obj2)

equalsIgnoreOrder

public static Boolean equalsIgnoreOrder(Object _obj1,
 Object _obj2)

contains

public static Boolean contains(Object _obj1,
 Object _obj2)

atn

public static double atn(double _number)

Returns a double specifying the arctangent of a number.

Parameters:

_number - a double or any valid numeric expression.

Returns:

arctangent

sqr

public static double sqr(double _number)

Returns a double specifying the square root of a number.

Parameters:

_number - a double greater than or equal to zero

Returns:

square root

cbool

public static boolean cbool(BigDecimal _value)

cbool

public static boolean cbool(Boolean _value)

Converts a value to a boolean.

Parameters:

_value - boolean input

Returns:

boolean

cbool

public static boolean cbool(String _value)

ccur

public static BigDecimal ccur(BigDecimal _value)

Converts an expression into a currency value.

cdate

public static Timestamp cdate(String _dt)

Converts an expression into a date value.

cdbl

public static Double cdbl(Double _number)

Converts an expression to a double.

cdec

public static Double cdec(Double _number)

cint

public static Short cint(Double _number)

cint

public static Short cint(boolean _boolean)

clng

public static Integer clng(Double _value)

Converts an expression to a long integer.

clng

public static Integer clng(String _value)
                    throws UcanaccessSQLException

Throws:

UcanaccessSQLException

clng

public static Integer clng(Integer _value)

clong

public static Integer clong(Double _value)

clong

public static Integer clong(Integer _value)

clong

public static Integer clong(boolean _value)

csign

public static double csign(double _value)

cstr

public static String cstr(Boolean _value)
                   throws UcanaccessSQLException

Converts a value to a string.

Throws:

UcanaccessSQLException

cstr

public static String cstr(String _value)

cstr

public static String cstr(double _value)
                   throws UcanaccessSQLException

Throws:

UcanaccessSQLException

cstr

public static String cstr(int _value)
                   throws UcanaccessSQLException

Throws:

UcanaccessSQLException

cstr

public static String cstr(Timestamp _value)
                   throws UcanaccessSQLException

Throws:

UcanaccessSQLException

cvar

public static String cvar(Double _value)
                   throws UcanaccessSQLException

Throws:

UcanaccessSQLException

dateAdd

public static Date dateAdd(String _intv,
 int _vl,
 Date _dt)
                    throws UcanaccessSQLException

Returns a date containing a date to which a specified time interval has been added.

Parameters:

_intv - interval of time

_vl - number of intervals to add (to get dates in the future) or dedcut (to get dates in the past)

_dt - date to which the interval is added

Returns:

calculated date

Throws:

UcanaccessSQLException - on invalid date interval input

dateAdd

public static Timestamp dateAdd(String _intv,
 int _vl,
 Timestamp _dt)
                         throws UcanaccessSQLException

Throws:

UcanaccessSQLException

dateAdd

public static Timestamp dateAdd(String _intv,
 int _vl,
 String _dt)
                         throws UcanaccessSQLException

Throws:

UcanaccessSQLException

dateDiff

public static Integer dateDiff(String _intv,
 String _dt1,
 String _dt2)
                        throws UcanaccessSQLException

Throws:

UcanaccessSQLException

dateDiff

public static Integer dateDiff(String _intv,
 String _dt1,
 Timestamp _dt2)
                        throws UcanaccessSQLException

Throws:

UcanaccessSQLException

dateDiff

public static Integer dateDiff(String _intv,
 Timestamp _dt1,
 String _dt2)
                        throws UcanaccessSQLException

Throws:

UcanaccessSQLException

dateDiff

public static Integer dateDiff(String _intv,
 Timestamp _dt1,
 Timestamp _dt2)
                        throws UcanaccessSQLException

Throws:

UcanaccessSQLException

datePart

public static Integer datePart(String _intv,
 String _dt,
 Integer _firstDayOfWeek)
                        throws UcanaccessSQLException

Throws:

UcanaccessSQLException

datePart

public static Integer datePart(String _interval,
 Timestamp _date,
 Integer _firstDayOfWeek)
                        throws UcanaccessSQLException

Returns an integer containing the specified part of a given date.

Parameters:

_interval - interval of time you want to return

_date - value that you want to evaluate

_firstDayOfWeek - constant that specifies the first day of the week

Returns:

date part

Throws:

UcanaccessSQLException - on invalid date interval input

datePart

public static Integer datePart(String _intv,
 String _dt,
 Integer _firstDayOfWeek,
 Integer _firstWeekOfYear)
                        throws UcanaccessSQLException

Throws:

UcanaccessSQLException

datePart

public static Integer datePart(String _intv,
 Timestamp _dt,
 Integer _firstDayOfWeek,
 Integer _firstWeekOfYear)
                        throws UcanaccessSQLException

Throws:

UcanaccessSQLException

datePart

public static Integer datePart(String _intv,
 String _dt)
                        throws UcanaccessSQLException

Throws:

UcanaccessSQLException

datePart

public static Integer datePart(String _intv,
 Timestamp _dt)
                        throws UcanaccessSQLException

Throws:

UcanaccessSQLException

dateSerial

public static Timestamp dateSerial(int _year,
 int _month,
 int _day)

Returns a date for a specified year, month, and day.

Parameters:

_year - number between 100 and 9999, inclusive, or a numeric expression

_month - any numeric expression

_day - any numeric expression

Returns:

date

dateValue

public static Timestamp dateValue(String _dt)

timestamp0

public static Timestamp timestamp0(String _dt)

dateValue

public static Timestamp dateValue(Timestamp _dt)

Returns a date based on a string. If the given string does not include a year component, this function will use the current year.

format

public static String format(Double _d,
 String _par)
                     throws UcanaccessSQLException

Throws:

UcanaccessSQLException

format

public static String format(String _s,
 String _par)
                     throws UcanaccessSQLException

Throws:

UcanaccessSQLException

format

public static String format(String _s,
 String _par,
 boolean _incl)
                     throws UcanaccessSQLException

Throws:

UcanaccessSQLException

format

public static String format(Timestamp _t,
 String _par)
                     throws UcanaccessSQLException

Throws:

UcanaccessSQLException

iif

public static String iif(Boolean _b,
 String _o1,
 String _o2)

Returns one of two parts, depending on the evaluation of an expression.

iif

public static Integer iif(Boolean _b,
 Integer _o1,
 Integer _o2)

iif

public static Double iif(Boolean _b,
 Double _o1,
 Double _o2)

iif

public static Boolean iif(Boolean _b,
 Boolean _o1,
 Boolean _o2)

iif

public static Timestamp iif(Boolean b,
 Timestamp _o1,
 Timestamp _o2)

instr

public static Integer instr(Integer _start,
 String _text,
 String _search)

Returns the position of the first occurrence of a string in another string.

instr

public static Integer instr(Integer start,
 String text,
 String search,
 Integer compare)

instr

public static Integer instr(String text,
 String search)

instr

public static Integer instr(String text,
 String search,
 Integer compare)

instrrev

public static Integer instrrev(String text,
 String search)

Returns the position of the first occurrence of a string in another string, starting from the end of the string.

instrrev

public static Integer instrrev(String text,
 String search,
 Integer start)

instrrev

public static Integer instrrev(String text,
 String search,
 Integer start,
 Integer compare)

isDate

public static boolean isDate(String _value)

Returns true if the expression is a valid date, otherwise false.

isDate

public static boolean isDate(Timestamp _value)

isNull

public static boolean isNull(String _value)

Returns true if the expression is a null value, otherwise false.

isNull

public static boolean isNull(Timestamp _value)

isNull

public static boolean isNull(Double _value)

isNumeric

public static boolean isNumeric(BigDecimal b)

Returns true if the expression is a valid number, otherwise false.

isNumeric

public static boolean isNumeric(String _s)

left

public static String left(String _input,
 int _i)

Extracts a substring from a string, starting from the left-most character.

leftS

public static String leftS(String input,
 int i)

len

public static Integer len(String _value)

Returns the length of the specified string.

mid

public static String mid(String _value,
 int start)

Extracts a substring from a string (starting at any position).

mid

public static String mid(String _value,
 int start,
 int length)

monthName

public static String monthName(int _number)
                        throws UcanaccessSQLException

Returns a string representing the month given a number from 1 to 12.

Throws:

UcanaccessSQLException

monthName

public static String monthName(int _number,
 boolean _abbreviate)
                        throws UcanaccessSQLException

Throws:

UcanaccessSQLException

date

public static Timestamp date()

Returns the current system date.

now

public static Timestamp now()

Returns the current system date and time.

nz

public static String nz(String _value)

Returns the second argument if the first argument is null.

nz

public static Double nz(Double _value)

nz

public static Integer nz(Integer _value)

nz

public static BigDecimal nz(BigDecimal _value)

nz

public static String nz(String _value,
 String _other)

nz

public static BigDecimal nz(BigDecimal value,
 BigDecimal _other)

nz

public static Double nz(Double value,
 Double _other)

nz

public static Integer nz(Integer value,
 Integer _other)

sgn

public static short sgn(double _n)

Returns the sign of a number. If number > 0, it returns 1. If number = 0, it returns 0.

sign

public static short sign(double _n)

space

public static String space(Integer _nr)

Returns a string with a specified number of spaces.

str

public static String str(double d)

Returns a string representation of a number.

time

public static Timestamp time()

Returns the current system time.

val

public static Double val(String _val1)

Accepts a string as input and returns the numbers found in that string.

val

public static Double val(BigDecimal _val1)

weekdayName

public static String weekdayName(int _number)

Returns a string representing the day of the week given a number from 1 to 7.

weekdayName

public static String weekdayName(int _number,
 boolean _abbreviate)

weekdayName

public static String weekdayName(int _number,
 boolean _abbreviate,
 int _firstDayOfWeek)

weekDay

public static Integer weekDay(Timestamp _date)
                       throws UcanaccessSQLException

Returns a number representing the day of the week (a number from 1 to 7) given a date value.

Throws:

UcanaccessSQLException

weekDay

public static Integer weekDay(Timestamp _date,
 Integer _firstDayOfWeek)
                       throws UcanaccessSQLException

Throws:

UcanaccessSQLException

string

public static String string(Integer _nr,
 String _str)

Returns a Variant (String) containing a repeating character string of the length specified.

timeSerial

public static Timestamp timeSerial(Integer _h,
 Integer _m,
 Integer _s)

Returns a time given an hour, minute, and second value.

rnd

public static Double rnd()

Generates a random number (integer value).

rnd

public static Double rnd(Double _d)

strReverse

public static String strReverse(String _value)

Returns a string whose characters are in reverse order.

strConv

public static String strConv(String _value,
 int _conversion)

Returns a string converted as specified.

strComp

public static Integer strComp(String _value1,
 String _value2,
 Integer _type)
                       throws UcanaccessSQLException

Returns an integer value representing the result of a string comparison.

Throws:

UcanaccessSQLException

strComp

public static Integer strComp(String _value1,
 String _value2)
                       throws UcanaccessSQLException

Throws:

UcanaccessSQLException

mint

public static Integer mint(Double _value)

Returns the integer portion of a number.

mint

public static Short mint(boolean _value)

ddb

public static double ddb(double cost,
 double salvage,
 double life,
 double period)

ddb

public static double ddb(double cost,
 double salvage,
 double life,
 double period,
 double factor)

fv

public static double fv(double rate,
 int periods,
 double payment)

fv

public static double fv(double rate,
 int periods,
 double payment,
 double pv)

fv

public static double fv(double rate,
 int periods,
 double payment,
 double pv,
 double type)

pmt

public static double pmt(double rate,
 double periods,
 double pv)

pmt

public static double pmt(double rate,
 double periods,
 double pv,
 double fv)

pmt

public static double pmt(double rate,
 double periods,
 double pv,
 double fv,
 double type)

nper

public static double nper(double rate,
 double pmt,
 double pv)

nper

public static double nper(double rate,
 double pmt,
 double pv,
 double fv)

nper

public static double nper(double rate,
 double pmt,
 double pv,
 double fv,
 double type)

ipmt

public static double ipmt(double rate,
 double per,
 double nper,
 double pv)

ipmt

public static double ipmt(double rate,
 double per,
 double nper,
 double pv,
 double fv)

ipmt

public static double ipmt(double rate,
 double per,
 double nper,
 double pv,
 double fv,
 double type)

pv

public static double pv(double rate,
 double nper,
 double pmt)

pv

public static double pv(double rate,
 double nper,
 double pmt,
 double fv)

pv

public static double pv(double rate,
 double nper,
 double pmt,
 double fv,
 double type)

ppmt

public static double ppmt(double rate,
 int per,
 int nper,
 double pv)

ppmt

public static double ppmt(double rate,
 int per,
 int nper,
 double pv,
 double fv)

ppmt

public static double ppmt(double rate,
 int per,
 int nper,
 double pv,
 double fv,
 double type)

sln

public static double sln(double cost,
 double salvage,
 double life)

syd

public static double syd(double cost,
 double salvage,
 double life,
 double per)

rate

public static double rate(double nper,
 double pmt,
 double pv)

rate

public static double rate(double nper,
 double pmt,
 double pv,
 double fv)

rate

public static double rate(double nper,
 double pmt,
 double pv,
 double fv,
 double type)

rate

public static double rate(double nper,
 double pmt,
 double pv,
 double fv,
 double type,
 double guess)

formulaToNumeric

public static Double formulaToNumeric(Double res,
 String datatype)

formulaToNumeric

public static Double formulaToNumeric(Boolean res,
 String datatype)

formulaToNumeric

public static Double formulaToNumeric(String _res,
 String _datatype)

formulaToNumeric

public static Double formulaToNumeric(Timestamp res,
 String datatype)
                               throws UcanaccessSQLException

Throws:

UcanaccessSQLException

formulaToBoolean

public static Boolean formulaToBoolean(Boolean res,
 String datatype)

formulaToBoolean

public static Boolean formulaToBoolean(Double res,
 String datatype)

formulaToBoolean

public static Boolean formulaToBoolean(Timestamp res,
 String datatype)

formulaToBoolean

public static Boolean formulaToBoolean(String res,
 String datatype)

formulaToText

public static String formulaToText(String res,
 String datatype)

formulaToText

public static String formulaToText(Double res,
 String datatype)

formulaToText

public static String formulaToText(Boolean res,
 String datatype)

formulaToText

public static String formulaToText(Timestamp res,
 String datatype)
                            throws UcanaccessSQLException

Throws:

UcanaccessSQLException

formulaToDate

public static Timestamp formulaToDate(Timestamp res,
 String datatype)

formulaToDate

public static Timestamp formulaToDate(String res,
 String datatype)

formulaToDate

public static Timestamp formulaToDate(Boolean res,
 String datatype)
                               throws UcanaccessSQLException

Throws:

UcanaccessSQLException

orderJet

public static String orderJet(String s)

formulaToDate

public static Timestamp formulaToDate(Double res,
 String datatype)
                               throws UcanaccessSQLException

Throws:

UcanaccessSQLException

right

public static String right(String input,
 int i)

Extracts a substring from a string starting from the right-most character.

rightS

public static String rightS(String input,
 int i)

round

public static double round(double d,
 double p)

Returns a number rounded to a specified number of decimal places.

fix

public static Double fix(Double _number)

Returns the integer portion of a number.

Parameters:

_number - a double or any valid numeric expression, if null, null is returned

Returns:

integer portion

partition

public static String partition(Double _number,
 double start,
 double stop,
 double interval)