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

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

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

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

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

[.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