Filter
Top Products
Working With GIS
179
then the result type is floating point;
otherwise the result type is integer.
& string_expression &
string_expression
Returns the concatenation of two
strings. The result type is a string.
= expression = expression Returns TRUE if the two expressions
are equal and FALSE otherwise. '='
is synonymous with the EQUALS
operator. The result type is
logical_expression.
<> expression <> expression Returns TRUE if the two expressions
are not equal and FALSE otherwise.
The result type is
logical_expression.
<= expression <= expression Returns TRUE if the first expression
is less than or equal to the second
expression, and FALSE otherwise.
The result type is
logical_expression.
< expression < expression Returns TRUE if the first expression
is less than the second expression,
and FALSE otherwise. The result
type is logical_expression.
> expression > expression Returns TRUE if the first expression
is greater than the second
expression, and FALSE otherwise.
The result type is
logical_expression.
>= expression >= expression Returns TRUE if the first expression
is greater than or equal to the
second expression, and FALSE
otherwise. The result type is
logical_expression.
Datepart Specifiers
Dates are made up of dateparts: hours, minutes, seconds, years, months, days, and
so on. For example, the month datepart of the date July 4, 1776 is 7. The day part is
4, and the year part is 1776. In a field creation formula, datepart specifiers are used
as parameters to date functions (e.g. YEAR(), DATEDIFF(), etc.).
D: A datepart representing the day part of a date. 'DD' is a synonym for 'D'.
DW: A datepart representing day of the week for a date.
DY: A datepart representing the day of the year for a date. 'Y' is a synonym for 'DY'.
HH: A datepart representing the hour part of a date.
M: A datepart representing the month part of a date. 'MM' is a synonym for 'M'.
MI: A datepart representing the minutes part of a date. 'N' is a synonym for 'MI'.
MS: A datepart representing the milliseconds part of a date.
Q: A datepart representing quarters. 'QQ' is a synonym for 'Q'.