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 ()
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
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:
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
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
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, 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
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
--------- --------- --------- ---
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
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.