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
Original address: http://blog.csdn.net/xyzqiang/article/details/6577831Add and subtract functions for SQL Server Date: DATEDIFF DATEADDDATEDIFF: Returns the number of date boundaries and time boundaries across two specified dates, syntax: DATEDIFF
Add and subtract functions for SQL Server Date: DATEDIFF DATEADDDATEDIFF: Returns the number of date boundaries and time boundaries across two specified dates, syntax: DATEDIFF (datepart, StartDate, enddate) minus EndDate with StartDateNote:
SelectTimediff ('23:40:00','18:30:00'); --subtract two time select substring (Timediff ('23:40:00','18:30:00'),1,5) ----“ to:Ten"Subtract back hours: minutesSelectDateDiff'2008-08-08','2008-08-01'); --7-----Two date subtractionSelectTo_days ('2008-09
DateTime and smalldatetime represents the date and time data type for the date and time of day. Microsoft SQL Server stores values for datetime data types within two 4-byte integers. The first 4 bytes stores the number of days before or after base
The DB has a time in the array of char types, for example 20151111 12171220000, which now needs to be reduced by 5s, forming a time range and then writing the stored procedure. the idea is to convert the time to datetime first, and then the DateTime
The new date and time types in SQL Server 2008 are datetime2 and datetimeoffset.
Datetime2 data type, It is similar to the datetime type, but its precision is relatively high. It can be precise to the last 7 digits (100ns) after the decimal point.
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.