What do you want to save?
Add Code snippet
New code examples
-
SQL 2021-10-26 07:46:09
sql beginning of previous month
SELECT DATEADD(d,1,EOMONTH(GETDATE(),-2)) Add solution -
SQL 2021-10-25 06:30:07
convert series number to date in sql
dateadd(d,36464,'1899-12-30') Add solution -
PHP 2021-10-19 16:35:09
mysql between all months days even null
DECLARE @StartDate DATETIME DECLARE @EndDate DATETIME SET @StartDate ='2014-03-01' SET @EndDate = GETDATE() ;WITH Dates(Date) AS ( SELECT DATEADD(dd, 0, DATEDIFF(dd, 0, @StartDate)) AS Date UNION ALL SELECT DATEADD(day, 1, Date) AS Date ... Add solution -
-
SQL 2021-10-16 03:48:07
sql find longest running job step
/*============================================= Variables: @MinHistExecutions - Minimum number of job step executions we want to consider @MinAvgSecsDuration - Threshold for minimum job step duration we care to monitor @HistoryStartDate ... Add solution -
SQL 2021-10-15 14:12:20
how to add month in update sql
UPDATE users SET date = DATEADD(MONTH, 1, date) Add solution -
SQL 2021-10-07 21:41:03
sql server query for datediff
-- DOES NOT ACCOUNT FOR LEAP YEARS DECLARE @date1 DATETIME, @date2 DATETIME, @result VARCHAR(100); DECLARE @years INT, @months INT, @days INT, @hours INT, @minutes INT, @seconds INT, @milliseconds INT; SET @date1 = '1900-01-01 00:00:00.000' SET @date... Add solution
Best helpers
Sylvia Bryan
+5
Mikeonly
+5
Martisj
+5
Eric Vavylon
+5
Y2k
+5
Paisleykaat
+5
Tammam
+5
Kadeem
+5
T.A. N
+5
KingW3
+5
Harindra
+5
NFL
+5
Rajendra
+5
Fdsuhygfuig
+5