CDate function
Returns an expression that has been converted to a Variantof the Date subtype.
CDate(date)
The date parameter is any valid datetime expression.
Description
The IsDate function is used to determine whether date can be converted to a
Cdate Function
Return expression, which has been convertedDateChild typeVariant.
Cdate (Date)
DateThe parameter is any valid date expression.Description
IsdateFunction used to judgeDateWhether it can be converted to date or time.CdateRecognize
A1, select Update_date, convert (varchar (), update_date,111) JJ, CONVERT (varchar (), update_date,8) AA from Report_ Month//update_date is a datetime type and results are shown as:Update_date JJ AA2007-01-06 16:14:50.437 2007/01/06 16:14:50Select
Each function can combine expressions (expressions: arithmetic or logical operators, constants, functions and field names, controls, and attributes. The calculation result is a single value. Expressions can perform computation, Operation characters,
/*
-- Function: Convert the string to the year, month, and day format, and delete the time, minute, and second.
-- Source: http://jorkin.reallydo.com/article.asp? Id = 529
-- Parameter:
Datechar varchar2
-- Oracle9i passed the test
*/
Create or
vbscript| Function | conversion CBool function
Describe
Returns an expression that has been converted to a Variant (variable) of a Boolean (Boolean type/subtype) subtype.
Grammar
CBool (expression)
expression is any valid
Date Format String specification, Format String Specification
From http://yanwushu.sinaapp.com /? P = 16
Yyyy-MM-dd HH: mm: ss is a date formatted string. This document describes the specifications of this string.
Case
Each function can set the expression(Expression: Any combination of arithmetic or logical operators, constants, functions and field names, controls, and attributes. The calculation result is a single value. Expressions can perform computation,
Network communication is the most commonly used data communication format is XML and JSON, each has its own benefits, anyway, this format, we are often used in the process of development, now in these two formats to take notes, the following content
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.