Solved

C# DateTime insert to DateTime in Access DB

Posted on 2009-07-08
3
1,342 Views
Last Modified: 2012-05-07
I have problem sto insert a DateTime from C# into a Access Table. What format am I supposed to have when inserting it? Are there any location dependent issues?
0
Comment
Question by:mdoland
3 Comments
 
LVL 33

Expert Comment

by:Todd Gerbert
ID: 24803916
What is the column type in your access database, and how are you [attempting to] insert a DateTime?
0
 
LVL 70

Accepted Solution

by:
Éric Moreau earned 500 total points
ID: 24804080
Usually, sending the date in the yyyy/MM/dd HH:mm:ss format is accepted in all cultures
0
 
LVL 49

Expert Comment

by:Gustav Brock
ID: 24804814
A DateTime has no format but if you wish to create an SQL string for the purpose you should use the format mentioned by emoreau.

/gustav
0

Featured Post

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

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

Calculating holidays and working days is a function that is often needed yet it is not one found within the Framework. This article presents one approach to building a working-day calculator for use in .NET.
This article aims to explain the working of CircularLogArchiver. This tool was designed to solve the buildup of log file in cases where systems do not support circular logging or where circular logging is not enabled
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

776 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