Namespace YndigoBlue.Velocity.Functions
Classes
- Abs
Represents the ABS (absolute value) mathematical function that returns the non-negative value of a number.
- Acos
Represents the ACOS (arccosine) inverse trigonometric function that calculates the angle whose cosine is the input.
- All
Represents the ALL quantified comparison operator that tests if a condition is true for all values in a subquery.
- Any
Represents the ANY quantified comparison operator that tests if any value in a subquery satisfies a condition.
- Asin
Represents the ASIN (arcsine) inverse trigonometric function that calculates the angle whose sine is the input.
- Atan
Represents the ATAN (arctangent) inverse trigonometric function that calculates the angle whose tangent is the input.
- Atan2
Represents the ATAN2 two-argument arctangent function that calculates the angle between the positive x-axis and a point.
- Average
Represents the AVG aggregate function that calculates the arithmetic mean of numeric values.
- Cast
Represents the CAST type conversion function that explicitly converts a value to a specified data type.
- Ceiling
Represents the CEILING mathematical function that rounds a number up to the nearest integer.
- Coalesce
Represents the COALESCE function that returns the first non-null value from a list of expressions.
- Concat
Represents the CONCAT string function that combines multiple strings into one.
- Cos
Represents the COS (cosine) trigonometric function that calculates the cosine of an angle.
- Count
Represents the COUNT aggregate function that returns the number of rows or non-null values.
- CountDistinct
Represents the COUNT(DISTINCT) aggregate function that returns the number of unique non-null values.
- Day
Represents the DAY date extraction function that returns the day of the month component of a date.
- Degrees
Represents the DEGREES conversion function that converts radians to degrees.
- Exists
Represents the EXISTS operator that tests whether a subquery returns any rows.
- Floor
Represents the FLOOR mathematical function that rounds a number down to the nearest integer.
- Hour
Represents the HOUR time extraction function that returns the hour component of a datetime.
- IndexOf
Represents the CHARINDEX/INSTR function that finds the position of a substring within a string.
- Int
Represents the INT (integer) mathematical function that truncates a number to its integer part.
- Left
Represents the LEFT string function that returns a specified number of characters from the start of a string.
- Length
Represents the LENGTH string function that returns the number of characters in a string.
- Lower
Represents the LOWER string function that converts all characters in a string to lowercase.
- Max
Represents the MAX aggregate function that returns the maximum value in a set.
- Min
Represents the MIN aggregate function that returns the minimum value in a set.
- Minute
Represents the MINUTE time extraction function that returns the minute component of a datetime.
- Mod
Represents the MOD (modulo) mathematical function that returns the remainder of a division operation.
- Month
Represents the MONTH date extraction function that returns the month component of a date.
- NotExists
Represents the NOT EXISTS operator that tests whether a subquery returns no rows.
- Now
Represents the NOW date/time function that returns the current date and time.
- NullIf
Represents the NULLIF function that returns NULL if two expressions are equal, otherwise returns the first expression.
- Power
Represents the POWER mathematical function that raises a base number to a specified exponent.
- Radians
Represents the RADIANS conversion function that converts degrees to radians.
- Rand
Represents the RAND mathematical function that generates a random number.
- Random
Represents the RANDOM mathematical function that generates a random number.
- Replace
Represents the REPLACE string function that substitutes all occurrences of a substring with another.
- Right
Represents the RIGHT string function that returns a specified number of characters from the end of a string.
- Round
Represents the ROUND mathematical function that rounds a number to a specified number of decimal places.
- Second
Represents the SECOND time extraction function that returns the second component of a datetime.
- Sin
Represents the SIN (sine) trigonometric function that calculates the sine of an angle.
- SpatialArea
Represents the ST_Area spatial function that calculates the area of a polygon or multi-polygon geometry.
- SpatialBoundary
Represents the ST_Boundary spatial analysis function that returns the boundary of a geometry.
- SpatialBuffer
Represents the ST_Buffer spatial analysis function that creates a buffer zone around a geometry or geography.
- SpatialCentroid
Represents the ST_Centroid spatial analysis function that computes the geometric center of a geometry.
- SpatialConcaveHull
Represents the ST_ConcaveHull spatial analysis function that computes a concave hull (alpha shape) around a geometry.
- SpatialContains
Represents the ST_Contains spatial predicate that tests if one geometry completely contains another.
- SpatialConvexHull
Represents the ST_ConvexHull spatial analysis function that computes the smallest convex polygon containing a geometry.
- SpatialCovers
Represents the ST_Covers spatial predicate function that tests if one geometry completely covers another.
- SpatialCrosses
Represents the ST_Crosses spatial predicate function that tests if two geometries cross each other.
- SpatialDifference
Represents the ST_Difference spatial analysis function that computes the spatial difference of two geometries.
- SpatialDimension
Represents the ST_Dimension spatial property function that returns the inherent dimension of a geometry.
- SpatialDisjoint
Represents the ST_Disjoint spatial predicate function that tests if two geometries have no points in common.
- SpatialDistance
Represents the ST_Distance spatial function that calculates the minimum distance between two geometries or geographies.
- SpatialEndPoint
Represents the ST_EndPoint spatial accessor function that returns the last point of a linestring geometry.
- SpatialEnvelope
Represents the ST_Envelope spatial analysis function that returns the bounding rectangle of a geometry.
- SpatialEquals
Represents the ST_Equals spatial predicate that tests if two geometries are spatially equal.
- SpatialExteriorRing
Represents the ST_ExteriorRing spatial accessor function that returns the exterior ring of a polygon geometry.
- SpatialGeometryType
Represents the ST_GeometryType spatial property function that returns the type of a geometry as a string.
- SpatialInteriorRingN
Represents the ST_InteriorRingN spatial accessor function that returns the Nth interior ring (hole) of a polygon geometry.
- SpatialIntersection
Represents the ST_Intersection spatial analysis function that computes the spatial intersection of two geometries.
- SpatialIntersects
Represents the ST_Intersects spatial predicate function that tests if two geometries have any points in common.
- SpatialIsClosed
Represents the ST_IsClosed spatial property function that tests whether a linestring or multi-linestring is closed.
- SpatialIsEmpty
Represents the ST_IsEmpty spatial validation function that tests whether a geometry is empty.
- SpatialIsRing
Represents the ST_IsRing spatial validation function that tests whether a linestring is a valid ring.
- SpatialIsSimple
Represents the ST_IsSimple spatial validation function that tests whether a geometry has no self-intersections.
- SpatialIsValid
Represents the ST_IsValid spatial validation function that tests whether a geometry is topologically valid.
- SpatialLength
Represents the ST_Length spatial measurement function that computes the length of a linear geometry.
- SpatialNumGeometries
Represents the ST_NumGeometries spatial property function that returns the number of component geometries in a geometry collection.
- SpatialNumInteriorRing
Represents the ST_NumInteriorRing spatial property function that returns the number of interior rings (holes) in a polygon.
- SpatialNumPoints
Represents the ST_NumPoints spatial property function that returns the number of points in a geometry.
- SpatialOverlaps
Represents the ST_Overlaps spatial predicate function that tests if two geometries overlap.
- SpatialPointN
Represents the ST_PointN spatial accessor function that returns the Nth point in a linestring geometry.
- SpatialPointOnSurface
Represents the ST_PointOnSurface spatial analysis function that returns a point guaranteed to be on the geometry's surface.
- SpatialRelate
Represents the ST_Relate spatial function that tests if two geometries satisfy a DE-9IM pattern.
- SpatialSrid
Represents the ST_SRID spatial property function that returns the Spatial Reference System Identifier of a geometry.
- SpatialStartPoint
Represents the ST_StartPoint spatial accessor function that returns the first point of a linestring geometry.
- SpatialSymDifference
Represents the ST_SymDifference spatial analysis function that computes the symmetric difference of two geometries.
- SpatialTouches
Represents the ST_Touches spatial predicate function that tests if two geometries touch at their boundaries but not interiors.
- SpatialUnion
Represents the ST_Union spatial analysis function that computes the spatial union of two geometries.
- SpatialWithin
Represents the ST_Within spatial predicate function that tests if one geometry is completely inside another.
- SpatialX
Represents the ST_X spatial accessor function that returns the X coordinate of a point geometry.
- SpatialY
Represents the ST_Y spatial accessor function that returns the Y coordinate of a point geometry.
- Sqrt
Represents the SQRT (square root) mathematical function that returns the principal square root of a number.
- Substring
Represents the SUBSTRING function that extracts a portion of a string.
- Sum
Represents the SUM aggregate function that calculates the total of numeric values.
- Tan
Represents the TAN (tangent) trigonometric function that calculates the tangent of an angle.
- Today
Represents the TODAY date function that returns the current date without the time component.
- Trim
Represents the TRIM string function that removes leading and trailing whitespace.
- TrimLeft
Represents the LTRIM (left trim) string function that removes leading whitespace.
- TrimRight
Represents the RTRIM (right trim) string function that removes trailing whitespace.
- Upper
Represents the UPPER string function that converts all characters in a string to uppercase.
- Year
Represents the YEAR date extraction function that returns the year component of a date.