1
Download Sybase InfoMaker 11.5, CD, Win, ENG
Transcript
CHAPTER 24 DataWindow Expression and InfoMaker Functions
Today
Description
Obtains the system date and time.
Syntax
Today ( )
Return value
DateTime. Returns the current system date and time.
Usage
To display both the date and the time, a computed field must have a display
format that includes the time.
Examples
This expression for a computed field displays the date and time when the
display format for the field is "mm/dd/yy hh:mm":
Today()
See also
Now
Trim
Description
Removes leading and trailing spaces from a string.
Syntax
Trim ( string )
Argument
string
Description
The string you want returned with leading and trailing spaces
deleted
Return value
String. Returns a copy of string with all leading and trailing spaces deleted if it
succeeds and the empty string (“”) if an error occurs.
Usage
Trim is useful for removing spaces that a user might have typed before or after
newly entered data.
Examples
This expression returns BABE RUTH:
Trim(" BABE RUTH ")
See also
LeftTrim
RightTrim
Truncate
Description
Truncates a number to the specified number of decimal places.
Syntax
Truncate ( x, n )
Users Guide
753
