Posted By: Anonymous
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?
DateTime values should be inserted as if they are strings surrounded by single quotes:
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
SQL Server also recognizes a generic format that is always interpreted the same way:
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 )