xSQL Reference Table of Contents
xSQL Reference Guide Table of Contents
String Manipulation
- Ascii
- CapFirstLetters
- Char
- CharAt
- Concat
- Contains
- CountMatches
- EndsWith
- IndexOf
- IsRegexMatch
- Lcase
- LeftSide
- Length
- Locate
- Lowercase
- Ltrim
- RemoveChars
- RemoveCharsAt
- Replace
- ReplaceAll
- RightSide
- Rtrim
- Space
- StartsWith
- StrLength
- SubString
- ToName
- ToQwerty
- Trim
- Ucase
- UpperCase
Date and Time Functions
- Overview: Date and Time Data Types
- AddDays
- CountWeekdays
- CurDate
- CurTime
- CurDateTime
- DayName
- DayOfMonth
- DayOfWeek
- DayOfYear
- DiffDays
- DiffTime
- EndOfMonth
- EndOfYear
- FormatDateTime
- Hour
- HourOfDay
- Millis
- Minute
- MinuteOfHour
- Month
- MonthName
- Nanos
- Now
- Quarter
- Second
- SecondOfMinute
- StartOfMonth
- StartOfYear
- SubtractDays
- Today
- TodayUTC
- Tomorrow
- UTCDate
- UTCDateTime
- Week
- WithZDefault
- WithZOffset
- WithZoneSameDateTime
- WithZoneSameInstant
- Year
- Yesterday
- ZoneId
- ZoneName
Math
Miscellaneous
- AllTypes
- Compare
- Empty
- MaxValue
- MinValue
- NextNum
- NVL
- ReadFile
- SeqNum
- Sleep
- ToScalar
- TypeNameOf
- TypeOf
- UUID
- Expand
- Explode
- Rotate
Numeric
Data Type Conversion and Validation
- ToDateTime
- ToDecimal
- ToDouble
- ToFloat
- ToInstant
- ToInteger
- IsDateTimeFormat
- ToOffsetDateTime
- ToOffSetTime
- ToTime
- ToZonedDateTime
Error Checking and Handling
Aggregate
xSQL Lookup Functions
- IsValidEmployeeId
- IsValidPeriodDateWithBatchName
- IsValidUnitTypeId
- IsValidUnitTypeName
- LookupBatchIdByName
- LookupBatchTypeIdByName
- LookupBatchTypeNamebyBatchId
- LookupBatchTypeNameByBatchName
- LookupBatchTypeNameby
- LookupOrderStageIdByOrderCodeItemCode
- LookupOrderStageUnitTypeIdOrderCodeItemCode
- LookupParticipantNameByEmployeeId
- LookupPeriodIdByName
- LookupPeriodTypeByPeriodName
- LookupProductIdByName
- LookupSplitTotalByOrderCodeItemCode