What do you want to save?
Add Code snippet
New code examples
-
SQL 2022-03-12 07:25:04
REMOVE DATE FROM DATE TIME SQL SERVER
First thing's first, if your dates are in varchar format change that, store dates as dates it will save you a lot of headaches and it is something that is best done sooner rather than later. The problem will only get worse. Secondly, once you have a date... Add solution -
Delphi 2022-02-02 17:26:35
INSERT into syntax error in delphi
ADOquery1.SQL.Add('Insert into admins'); ADOquery1.SQL.Add('([Name] , [Surname], [Dateadded], [Adminnumber], [Password])'); ADOquery1.SQL.Add('Values (:Name, :Surname, :Dateadded, :adminnumber, :Password)'); ADOquery1.Parameters.ParamByName('Name').Valu... Add solution -
SQL 2022-01-30 23:55:26
sql datediff month
-- 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 -
SQL 2021-11-20 17:24:18
sql today at midnight
SELECT DATEADD(d, 0, DATEDIFF(d, 0, GETDATE())) Add solution -
-
SQL 2021-11-06 00:35:15
sql getdate minus 1 day without time
DATEADD(DAY, -30, GETDATE()) Add solution