Introduction
On the computerProgramIt is difficult to accurately process the date in. Not only are there obvious (English: January, French: Janvier, German: Januar, etc.) Internationalization requirements, different date systems must also be
CONVERT (Data_type,expression[,style])CONVERT (varchar (10), field name, conversion format)DescriptionThis style is typically in the time type (Datetime,smalldatetime) and the string type (Nchar,nvarchar,char,varchar)It is only used when converting
Reproduced in this blog, the original blog: http://blog.csdn.net/baiduandxunlei/article/details/9180075CONVERT (Data_type,expression[,style])CONVERT (varchar (10), field name, conversion format)DescriptionThis style is typically in the time type
Country
Enables the MS-DOS subsystem to use international time, date, currency, case conversions, and decimal separators.
Grammar
Country=xxx[,[yyy][,[drive:][path] [FileName]]
Parameters
Xxx
Specifies the country/region code.
yyy
Specifies the
Use convert in SQL server2000 to get processing of datetime data type style (full) Date data formats, two examples: CONVERT (varchar (16), time one, 20) results: 2007-02-01 08:02/* Time is generally getdate () function or field in the data table
Use convert in SQL server2000 to get the datetime data type style (full)Processing of date data formats, two examples:CONVERT (varchar (16), time one, 20) results: 2007-02-01 08:02/* time is generally a field in the GETDATE () function or data table
My code:
Convert (date, mydatetime)
Bytes --------------------------------------------------------------------------------------------------------------------------
Generally, the time format stored in the database isYyyy-mm-DDHH: mm: SSIf you want
In 1916, Germany first introduced daylight saving time, the UK because of fear of Germany will get greater benefits, so closely followed also took daylightFrom 1986 to 1991, the People's Republic of China practiced daylight saving time for six years
I. ConvertCONVERT (varchar), GETDATE (), +): varchar (10) The number of intercept bits can be adjusted, can display up to 19 bits (varchar (19))such as: 2009-12-12 10:10:10-2009-12-12
no century digits (yy) (1)
Today, I encountered the problem of converting the date field. After the problem was solved with the help of SQL king, I found the relevant materials on the Internet to learn!SqlDataSource1.SelectCommand = "SELECT ***** '+ RIGHT (XkzSqs. QYMC, LEN
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.