mSchmidt
asked on
Adding DateTime field to SQLServers DateTime field
Hi
I have a couple of DateTime values as these...
private DateTime callStarted;
How is the easiest way to add these to a new row in a table also with the DateTime fields.. i have tried it using an insert statement but they dont seem to be compatible.. is there an Easier/better way ?
I have a couple of DateTime values as these...
private DateTime callStarted;
How is the easiest way to add these to a new row in a table also with the DateTime fields.. i have tried it using an insert statement but they dont seem to be compatible.. is there an Easier/better way ?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
what you find as incompatible?
You can use the DataTime.Parse method to set the culture info/format info.
http://msdn2.microsoft.com/en-us/library/system.datetime.parse.aspx
Here is a sample code in C# inserting date values to the date field.
http://www.c-sharpcorner.com/Code/2005/Feb/MSaccessDateInsert.asp