Home

Technical Resources

What are the commonly used functions of informix?

211

informix function php language Detailed explanation substr_count() apply javascript python sort() min() abs php round c language truncation function trunc truncf truncl mysql substring() method function strtolower() trim str_replace current_time current_date()

Table of Contents

What are the commonly used functions of informix?

Commonly used functions in informix include mathematical functions, string functions, date and time functions, data type conversion functions, sorting and grouping functions, connection functions, conditional functions, statistical functions, subquery functions and date and time functions. Detailed introduction: 1. Mathematical functions, AVG(), COUNT(), MAX(), MIN(), SUM(), ABS(), ROUND(), TRUNC(); 2. String functions, LENGTH(), SUBSTRING() and so on.

Oct 16, 2023 am 11:08 AM

informix function

Detailed explanation of the usage of substr_count() function in PHP language

PHP is a widely used programming language that is widely used in web development. In these projects, string processing is an important part that cannot be bypassed. In PHP, there are many built-in functions for string processing. For example, functions such as substr_count() can quickly count the number of times a certain substring appears in a given string. In this article, we will introduce the usage of substr_count() function in detail. Syntax substr_count(string$hays

Jun 27, 2023 am 10:17 AM

php language Detailed explanation substr_count()

Introduction to apply and Math.max() functions in js

This article mainly introduces to you the problems of apply and Math.max() functions in js. At the bottom of the article, I mentioned the difference between Math.max.apply and Math.max in js. I hope it can help you.

Mar 28, 2018 am 09:05 AM

apply javascript

How to use Python's sort(), min(), and max() functions to sort list elements?

The sort0 method is provided in the list object, which is used to sort the elements in the original list. After sorting, the order of the elements in the original list will change. The syntax format is as follows: listname.sort(key=None, reverse=False) key: key used for comparison reverse: optional parameter False means ascending order True means descending order The default ascending order When using the sort0 method to sort a string list , the rule adopted is to sort uppercase letters first, then lowercase letters. If you want to sort the string list (case-insensitive), you need to specify its key parameter. Case insensitive char.sort(key=st

May 09, 2023 pm 05:37 PM

python sort() min()

How do we use MySQL SUM() function?

The MySQLSUM function is used to calculate the sum of a field in multiple records. To understand the SUM() function, consider an "employee_tbl" table with the following records -mysql>SELECT*FROMemployee_tbl;+------+------+-------- ----+--------------------+|id |name|work_date |daily_typing_pages|+------+------+ ------------+--------------

Sep 05, 2023 am 11:53 AM

Using abs() to obtain the absolute value of parameters in php

In the daily use of PHP, we may need to obtain the absolute value of a variable. At this time, we can use the built-in abs() function in PHP. This article will take you to take a look.

May 07, 2021 am 11:35 AM

abs php

Detailed explanation of round() function in PHP

For numbers in PHP, there are two data types: Integer and Float. In some special circumstances, we can only use integer types, and for floating point types, we can only convert them to integer types. , PHP provides the round() function, which can help us complete this task. This article will take you to take a look.

Apr 20, 2021 am 09:55 AM

php round

In C language, trunc() represents a truncation function, truncf() represents a truncation function (single precision), and truncl() represents a truncation function (long double precision).

Here we will see three functions. These functions are trunc(), truncf() and truncl(). These functions are used to convert floating point values into truncated form. trunc() function This function is used to truncate double type values. And only the integer part is returned. The syntax is as follows. doubletrunc(doubleargument) example #include<stdio.h>#include<math.h>main(){ doublelea,b,x,y; x=53.26;&

Sep 09, 2023 am 10:53 AM

c language truncation function trunc truncf truncl

How to use the LENGTH() function in MySQL

The LENGTH()LENGTH(str) and OCTET_LENGTH(str) functions are used to return the byte length of a string, for example: SELECTLENGTH('MySQL String Function')ASlen1,OCTET_LENGTH('MySQL String Function')ASlen2;len1|len2 |----+----+20|20|In utf8mb4 encoding, one Chinese character occupies 3 bytes. In addition, the CHAR_LENGTH(str) and CHARACTER_LENGTH(str) functions are used to return

May 26, 2023 pm 09:40 PM

mysql

How to use the javascript substring() method

In JavaScript, the substring() method is used to extract the characters between two specified subscripts in the string, the syntax is "string.substring(from,to)"; the substring returned by this method includes the "from" parameter characters, but not including the character at the "to" parameter.

Mar 08, 2022 pm 06:14 PM

javascript substring() method

How to use the UPPER() function in MySQL

UPPER()UPPER(str) and UCASE(str) functions are used to convert strings to uppercase form, for example: SELECTUPPER('MySQL string function')ASstr1,UCASE('MySQL string function')ASstr2;str1|str2 |-------------+--------------+MYSQL string functions|MYSQL string functions|

May 26, 2023 pm 12:04 PM

mysql

Introduction to the use of PHP strtolower() function

PHP is a widely used server-side programming language. It provides numerous built-in functions to meet many needs of developers in their daily work. Among them, the strtolower() function is a commonly used string processing function. In this article, we will delve into how to use the strtolower() function and what to pay attention to. What is strtolower() function? The strtolower() function is one of PHP's built-in functions. Its function is to convert uppercase letters in a string to lowercase.

Jun 27, 2023 pm 07:42 PM

php function strtolower()

Detailed explanation of trim() function in PHP

The string obtained from the text box in the form may contain space characters or other strings. So how to remove these strings that we do not need? We can use the trim() function to solve this problem. This article Let’s take a look at it together.

Apr 28, 2021 am 11:04 AM

php trim

Detailed explanation of str_replace() function in php

This article mainly analyzes the str_replace() function through examples. During use, due to parameter problems, the replaced variables undergo different changes.

Mar 18, 2021 pm 04:18 PM

php str_replace

How to use mysql locate()

In mysql, locate() is mainly used for case-insensitive string searches. It can return the position of the first occurrence of a substring in a string; the syntax is "LOCATE(substring to be searched, string [ ,start])", the parameter "start" is omitted and specifies the starting position of the search. The default value is 1. If the substring is not found in the original string, the locate() function returns 0.

Jun 15, 2022 pm 03:00 PM

mysql

What is the difference between current_time/current_date() and now() in Mysql

current_date() only displays the date of the current time. For example: selectcurrent_date()froma; Result: 2021-08-25current_time() only displays the hours, minutes and seconds of the current time. For example: selectCURRENT_TIME()froma;14:07:06now() displays all For example: selectnow()froma; Result: 2021-08-2514:07:56 When increasing or decreasing date current_time, current_date() is similar to now(). The details are as follows: CURRENT_DATE() function #Get the current date

May 28, 2023 pm 02:17 PM

mysql current_time current_date()