These routines manipulate datetime and money datatypes. datetime and money datatypes come in long versions, DBDATETIME and DBMONEY, and short (4-byte) versions, DBDATETIME4 and DBMONEY4. All of the DBDATETIME4 routines listed below are also available for DBDATETIME, and all DBMONEY4 routines are available for DBMONEY. For example, dbmny4add, listed below, is also available as dbmnyadd.
dbdate4cmp – compares two DATETIME4 values.
dbdate4zero – initializes a DBDATETIME4 value.
dbmny4add – adds two DBMONEY4 values.
dbmny4cmp – compares two DBMONEY4 values.
dbmny4copy – copies a DBMONEY4 value.
dbmny4divide – divides one DBMONEY4 value by another.
dbmny4minus – negates a DBMONEY4 value.
dbmny4mul – multiplies a DBMONEY4 value.
dbmny4sub – subtracts a DBMONEY4 value.
dbmny4zero – initializes a DBMONEY4 value.
dbmnydec – decrements a DBMONEY value.
dbmnydown – divides a DBMONEY value by a positive integer.
dbmnyinc – increments a DBMONEY value.
dbmnyinit – prepares a DBMONEY value for calls to dbmnyndigit.
dbmnymaxneg – returns the maximum negative DBMONEY value.
dbmnymaxpos – returns the maximum positive DBMONEY value.
dbmnyndigit – returns the rightmost digit of a DBMONEY value as a DBCHAR.
dbmnyscale – multiplies a DBMONEY value and adds a specified amount.