how to insert datetime into the SQL Database table

Question

How can I insert datetime into the SQL Database table   Is there a way to insert this query through the insert command in C     NET

User · Answer

DateTime values should be inserted as if they are strings surrounded by single quotes '20201231' but in many cases they need to be casted explicitly to datetime CAST(N'20201231' AS DATETIME) to avoid bad execution plans with CONVERSION_IMPLICIT warnings that affect negatively the performance. Hier is an example:

CREATE TABLE dbo.T(D DATETIME)

--wrong way
INSERT INTO dbo.T (D) VALUES ('20201231'), ('20201231')

--better way
INSERT INTO dbo.T (D) VALUES (CAST(N'20201231' AS DATETIME)), (CAST(N'20201231' AS DATETIME))

User · Answer

if you got actuall time in mind GETDATE   would be the function what you looking for

User · Answer

DateTime values should be inserted as if they are strings surrounded by single quotes    20100301    SQL Server allows for many accepted date formats and it should be the case that most development libraries provide a series of classes or functions to insert datetime values properly  However  if you are doing it manually  it is important to distinguish the date format using DateFormat and to use generalized format   Set DateFormat MDY --indicates the general format is Month Day Year  Insert Table  DateTImeCol   Values   2011-03-12      By setting the dateformat  SQL Server now assumes that my format is YYYY-MM-DD instead of YYYY-DD-MM   SET DATEFORMAT  SQL Server also recognizes a generic format that is always interpreted the same way  YYYYMMDD e g  20110312   If you are asking how to insert the current date and time using T-SQL  then I would recommend using the keyword CURRENT TIMESTAMP  For example   Insert Table  DateTimeCol   Values  CURRENT TIMESTAMP

User · Answer

You will need to have a datetime column in a table   Then you can do an insert like the following to insert the current date   INSERT INTO MyTable  MyDate  Values  GetDate      If it is not today s date then you should be able to use a string and specify the date format   INSERT INTO MyTable  MyDate  Values  Convert DateTime  19820626  112   --6 26 1982   You do not always need to convert the string either  often you can just do something like   INSERT INTO MyTable  MyDate  Values   06 26 1982      And SQL Server will figure it out for you

User · Answer

myConn Execute  INSERT INTO DayTr  dtID  DTSuID  DTDaTi  DTGrKg  VALUES     amp  Val txtTrNo   amp       amp  Val txtCID   amp         amp  Format txtTrDate   yyyy-mm-dd    amp         amp  Val Format txtGross         0 00     amp        Done in vb with all text type variables

[.net] how to insert datetime into the SQL Database table?

Examples related to .net

Examples related to sql

Examples related to sql-server

Examples related to sql-server-2005

Examples related to c#-3.0