How to insert date in dd-MM-yyyy format?

Question

cmd.Parameters.Add("@Date", dtp_Date.Value);

This code is inserted date in "M/dd/yyyy" format but I want to insert date in dd-MM-yyyy format in ms access database.

The format of date is irrelevant when you are storing in database, You need to format it when you gonna use it e.g in presentation layer (form) to show the date — Adil, Jul 27 '15 at 07:28
database is ms access. I have already tagged and already mentioned @Code — Elixir, Jul 27 '15 at 07:30
@ZoharPeled, my question is different. I haven't found the answer from your given link — Elixir, Jul 27 '15 at 07:56
Check my answer. display format is not stored as data in ms access datetime column. — Zohar Peled, Jul 27 '15 at 09:06
The _already answered_ link bears no relevance to this question. That said, the answer was given by @Adil above (upvoted). — Gustav, Jul 27 '15 at 11:04

score 0 · Answer 1 · answered Jul 27 '15 at 07:27

0

You can store DateTime in any format in Database.

You require to convert when you want to show it on screem(e.g. View)

For that case use DateTime.TryParseExact:

 DateTime dtReturn;

DateTime.TryParseExact(dtp_Date.Value, 'dd-MM-yyyy', CultureInfo.InvarientCulture, DateTimeStyles.None, out dtReturn);

answered Jul 27 '15 at 07:27

Neel

11,625
3
43
61

Showing error in line @Neel – Elixir Jul 27 '15 at 07:47
error of overloaded method – Elixir Jul 27 '15 at 09:34

score 0 · Answer 2 · answered Jul 27 '15 at 07:27

0

I'm assuming your database field type is 'datetime' and dtp_date is ''String. If so, use the below line of code,

DateTime date = DateTime.ParseExact(dtp_Date, "dd-MM-yyyy", null);

answered Jul 27 '15 at 07:27

gkrishy

756
1
8
33

This line showing error – Elixir Jul 27 '15 at 07:39
can you Show the line of code that your dtp_Date has defined ? – gkrishy Jul 27 '15 at 08:40
Converts the value of current System.DateTime object to its equivalent string representation – Elixir Jul 27 '15 at 09:34
No, I'm asking in your c# code not error message. – gkrishy Jul 27 '15 at 10:02
DateTime date = DateTime.ParseExact(dtp_Date, "dd-MM-yyyy", null); a red line of error displaying below code – Elixir Jul 29 '15 at 08:09

score 0 · Answer 3 · answered Jul 27 '15 at 07:31

0

By assuming that you are inserting into a mysql database, it supports only yyyy-mm-dd format for date. you can format the date while retrieving it from the DB. Link for mysql date functions

answered Jul 27 '15 at 07:31

my database in ms access – Elixir Jul 27 '15 at 07:37

score 0 · Answer 4 · answered Jul 27 '15 at 08:24

Datetime in ms access is not stored with it's display format. In fact, it's stored as a double:

Access stores the Date/Time data type as a double-precision, floating-point number up to 15 decimal places. The integer part of the double-precision number represents the date. The decimal portion represents the time.

You should deal with display format when selecting from the table.

How to insert date in dd-MM-yyyy format?

4 Answers4