Solved

Adding DateTime field to SQLServers DateTime field

Posted on 2006-07-19
2
207 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

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…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial

739 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