Solved

Adding DateTime field to SQLServers DateTime field

Posted on 2006-07-19
2
203 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn 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…
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …

863 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

18 Experts available now in Live!

Get 1:1 Help Now