Search results
select min(period) as period, MIN(date), MAX(date) from (select t.*, (select min(date) from t t2 where t2.period <> t.period and t2.date > t.date) as nextp from t ) t group by nextp The inner subquery gets the date of the next period.
27 cze 2019 · Learn SQL Server date functions to get beginning and ending periods such as first day of the week, month, quarter, year, and dynamic end dates.
ALTER TABLE [DBName].[dbo].[TestDate] ADD End_Date as DATEADD(D, 7 * (Duration / 5) -- Business weeks as calendar days + CHOOSE(DATEPART(WEEKDAY, StartDate),-2,0,0,0,0,0,-1) -- Move weekend start to Friday, if needed + (Duration % 5) -- Day outside of full business weeks +IIF(DATEPART(dw, DATEADD(D, CHOOSE(DATEPART(WEEKDAY, StartDate),-2,0,0,0 ...
20 lip 2013 · We can use a query like below to get Quarter’s Start and End Date for a given date. DECLARE @AnyDate DATETIME SET @AnyDate = GETDATE() SELECT @AnyDate AS 'Input Date', DATEADD(q, DATEDIFF(q, 0, @AnyDate), 0) AS 'Quarter Start Date', DATEADD(d, -1, DATEADD(q, DATEDIFF(q, 0, @AnyDate) + 1, 0)) AS 'Quarter End Date'
18 lip 2019 · Learn to calculate Start / First of Week, End of Week, Start of Next Week, Year, Quarter, and Month of the week, Week Numbers and more in T-SQL (Jeff Moden)
14 gru 2016 · SYSTEM_TIME is used as PERIOD by checking start and End Time and this field also using for select statement to get history records from transaction and history tables. SELECT * FROM [Your_Table] FOR SYSTEM_TIME BETWEEN '2014-01-01 00:00:00.0000000' AND '2015-01-01 00:00:00.0000000'
Suppose you have a table named "tasks" with columns "task_id," "start_date," and "end_date." You want to find tasks that have a duration of more than 5 days. Here's a SQL query using the INTERVAL function to achieve this: SELECT task_id, start_date, end_date FROM tasks WHERE (end_date -start_date) > INTERVAL 5 DAY;
