What are the commonly used functions in Informix?

1 year ago
Emily Johnson
2 minutes

Informix database contains a variety of commonly used functions, including the following:

  1. String functions:
  1. LENGTH: Returns the length of the string.
  2. CONCAT: Joining two strings together.
  3. SUBSTRING: Returns a substring of a string.
  4. TRIM: Remove any extra spaces at the beginning or end of a string.
  1. Numeric function
  1. ABS: Returns the absolute value of a number.
  2. CEILING: Returns the smallest integer that is greater than or equal to the given number.
  3. FLOOR: Returns the maximum integer that is less than or equal to the given number.
  4. ROUND: Round the given number.
  1. Date and time functions:
  1. CURRENT：返回当前日期和时间。
  2. Extract the date part from the given date and time.
  3. – Extract the time part from the given date and time.
  4. TIMESTAMP: Combining a date and time to create a timestamp.
  1. Aggregate function:
  1. AVG calculates the average value of a numerical column.
  2. COUNT: Calculate the number of rows or the count of non-empty values.
  3. MAX: Retrieve the maximum value from a numeric column.
  4. MIN: Return the minimum value of the numerical column.
  5. Calculate the total sum of the numerical column.

This is just a small subset of commonly used functions available in Informix, there are many other functions that can be used for different purposes. For specific usage instructions, you can refer to Informix’s official documentation or search for relevant resources.

bannerAds