datediff function in sql

= mktime ($ hour, $ min, $ sec, $ month, $ day, $ year );Return $ ret;}/***** Simulate the datediff function in sqlserver *******$ Part type: StringValue Range: year, month, day, hour, Min, SecIndicates the part of the date to be added.$ Date1, $ date2 type: TimestampTwo dates to be comparedReturn type: Numeric Value* ************** End *(*************/Function

= mktime ($ hour, $ min, $ sec, $ month, $ day, $ year );Return $ ret;}/***** Simulate the datediff function in sqlserver *******$ Part type: stringValue Range: year, month, day, hour, min, secIndicates the part of the date to be added.$ Date1, $ date2 type: timestampTwo dates to be comparedReturn type: Numeric Value* ************** End *(*************/Function

--getdate Current system date, timeSelect getdate()--2014-11-24 13:22:40.407--the CONVERT () function can display date/time data in different formatsSelect Convert(varchar( -),getdate(), at)--2014-11-24--DateDiff Returns the number of date and time boundaries across two specified datesSelect DateDiff( Day,'2014-11-24','2014-12-28')-- theSelect

GetDate () 2.DateDiff (' s ', ' 2005-07-20 ', ' 2005-7-25 22:56:32 ') returns a value of 514,592 seconds DateDiff (' d ', ' 2005-07-20 ', ' 2005-7-25 22:56:32 ') returns a value of 5 days 3.DatePart (' W ', ' 2005-7-25 22:56:32 ') returns a value of 2 i.e. Monday (Sunday is 1, Saturday is 7) DatePart (' d ', ' 2005-7-25 22:56:32 ') returns a value of 25, or 25th DatePart (' y ', ' 2005-7-25 22:56:32 '

SQL Time function, the need for friends can refer to the next. 1. Current system date, time select GETDATE ()2. DateAdd returns a new datetime value based on adding a period of time to the specified date for example: Add 2 days to the date select DATEADD (day,2, ' 2004-10-15 ')--return: 2004-10-17 00:00:00.000For example: Query current time last three days contents in descending order select * from table w

') Select how many weeks of the year =datename (week, ' 2004-10-15 ') , today is the week =datename (weekday, ' 2004-10-15 ') function parameters/Functions GetDate () returns the current date and time of the system DateDiff (INTERVAL,DATE1,DATE2) returns the difference between Date2 and date1 two dates, as specified by interval date2-date1 DATEADD (interval,number,date) in the manner specified by interval,

You can understand that by using simple DATEDIFF and DATEADD functions, you can find many different dates that may be meaningful. All the examples so far only calculate the number of time intervals between the current time and "", and then add it The date is calculated based on the time interval of "1900-01-01. Assume that you modify the number of time intervals or use different time intervals to call The DATEADD

index from the beginning of the first, parameter three is to delete several, parameter four is the inserted stringSelect STUFF (' 123abc ', 4,3, ' hello ')--substring to intercept the specified length from the specified string--Parameter one is the original string, parameter two is to intercept the beginning of the index of the string, parameter three is the length of interceptionSelect SUBSTRING (' ABCDEFG ', 3, 1)--Time-date function--system consta

Label: ------------------date is converted into a month and a day and seconds--------------- Select ' R ' +convert (varchar), GETDATE (), 112)+right (CAST (Power (10,2) as varchar) +datepart (hour, GETDATE ()), 2)+right (CAST (Power (10,2) as varchar) +datepart (minute, GETDATE ()), 2)+right (CAST (Power (10,2) as varchar) +datepart (SS, GETDATE ()), 2)+right (CAST (Power (10,3) as varchar) +datepart (MS, GETDATE ()), 3) SQL Server t

random date within the specified interval, but we want to use the date and time of the two functions: DateAdd and DateDiff. Use DateDiff to calculate the interval value of the date interval, the same idea we calculated a random integer value, and then through the DATEADD to get our expectation of a random date. The T-SQL code for the encapsulated

Tags: 0.00 interval based on different str diff system article arithmetic operationsOne, SQL Server time Date function detailed 1. Current system date, time Select GETDATE () 2. DateAdd returns a new datetime value based on adding a period of time to the specified date Example: Add 2 days to the date Select DATEADD (day,2, ' 2004-10-15 ')--return: 2004-10-17 00:00:00.000 3.

above function is as follows: SELECT dbo.ufn_RandNum(, ) AS RandNum, dbo.ufn_RandNum(, ) AS RandNum; GO The query result after execution is as follows: Generate any random date in the date range We will continue to explain how to obtain any random date in the specified range, but we need to use two functions of date and time: DATEADD and DATEDIFF. Use DATEDIFF