Solved

Adding DateTime field to SQLServers DateTime field

Posted on 2006-07-19
2
202 Views
Last Modified: 2010-04-24
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 ?
0
Comment
Question by:mSchmidt
  • 2
2 Comments
 
LVL 15

Expert Comment

by:lakshman_ce
ID: 17140144
>>i have tried it using an insert statement but they dont seem to be compatible

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
0
 
LVL 15

Accepted Solution

by:
lakshman_ce earned 500 total points
ID: 17140165
0

Featured Post

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

Suggested Solutions

The following diagram presents a diamond class hierarchy: As depicted, diamond inheritance denotes when two classes (e.g., CDerived1 and CDerived2), separately extending a common base class (e.g., CBase), are sub classed simultaneously by a fourt…
In Easy String Encryption Using CryptoAPI in C++ (http://www.experts-exchange.com/viewArticle.jsp?aid=1193) I described how to encrypt text and recommended that the encrypted text be stored as a series of hexadecimal digits -- because cyphertext may…
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.

760 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now