Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Adding DateTime field to SQLServers DateTime field

Posted on 2006-07-19
2
Medium Priority
?
210 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 2000 total points
ID: 17140165
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

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…
Please read the paragraph below before following the instructions in the video — there are important caveats in the paragraph that I did not mention in the video. If your PaperPort 12 or PaperPort 14 is failing to start, or crashing, or hanging, …
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…

926 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