vbscript| function
1. Function Array ()
Function: Create an array variable
Format: Array (list)
Parameters: List of each numeric column in an array variable, separated by a comma
Example:
Result: I was given an array
2. Function CInt ()
million calendar, we must be familiar with it, the following is a calendar example using jquery, like friends can refer to the following The code is as follows:
Date functionDescription: Returns the current system date.Syntax: Date
DATEADD functionDescription: Returns the date when the specified time interval has been added.Syntax: DateAdd (interval, number, date)Interval: Must choose. A string expression
MySQL does not currently support column default for the form of a function, such as to achieve the default value of a column for the current update date and time function, you can use the timestamp column type
The following is a detailed
server| function
1, statistical functions AVG, COUNT, max, Min, sum
Most parties do not count rows with null values. You can work with distinct to remove duplicate rows. Can be grouped with GROUP by
2, Mathematical functions
SQRTCeiling (n) returns
DateDiff function
Returns a Variant (long) that represents the number of time intervals between two specified dates.
Grammar
DateDiff (interval, date1, date2[, firstdayofweek][, FirstWeekOfYear])
The following named arguments are in the
1. Abs function
Function Name: ABS
Main function: Find out the absolute value of the corresponding number.
Use format: ABS (number)
Parameter Description: number represents a value or a referenced cell that requires an absolute value.
Function
function, which is a function block encapsulated in the language, to facilitate the user's invocation. For example, "Now" in VBScript is a function that shows the current date and time. As for the specific reason for the display, the
function, which is a function block encapsulated in the language, to facilitate the user's invocation. For example, "Now" in VBScript is a function that shows the current date and time. As for the specific reason for the display, the language is
8. Datedif function
Function Name: DATEDIF
Main function: Calculates the difference that returns two date parameters.
Use format: =datedif (date1,date2, "Y"), =datedif (Date1,date2, "M"), =datedif (Date1,date2, "D")
Parameter Description: Date1
Single-record functions in SQL
1.ASCII returns the decimal number corresponding to the specified character;
Sql> Select ASCII (' a ') a,ascii (' A ') a,ascii (' 0 ') zero,ascii (') space from dual;
A A ZERO space
--------- --------- --------- ---
ASP function Encyclopedia
1. function Array ()
Function: Create an array variable
Format: Array (list)
Parameters: List of each numeric column in an array variable, separated by a comma
Example:
Result: I was given an array
2. function Cint ()
Beginner | function | A function that encapsulates a feature block in the language to facilitate user invocation. For example, "Now" in VBScript is a function that shows the current date and time. As for the specific reason for the display, the
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.