C# – ASP.NET C# MVC – Change format for datetime directly on DB or Model

asp.net-mvcc++datetime

I'm struggling myself trying to find an easy way to change the DateTime format for my Table field.

I have a Model called Article with a field called releaseDate that is a DateTime

I managed to do it (visually) by converting the

Article.releaseDate.ToString("dd/MM/yy")

but the thing is when I try to submit a date with this format from the create action it returns an error telling the the format is wrong.

Any easy way to change the default ("MM/dd/yy") to ("dd/MM/yy")?

Thanks in advance

Best Solution

You could change the culture information on a page by page basis by including

<%@ Page UICulture="en" Culture="en-GB" %>

or globally across all pages by adding to your web.config

<globalization uiCulture="en" culture="en-GB" />

Both will change the DateTime model binding to dd/MM/yyyy so no conversion is necessary.

See this question for more information

The code equivalent is

CultureInfo.CurrentUICulture.DateTimeFormat
 = CultureInfo.CurrentCulture.DateTimeFormat
 = new CultureInfo( "en-GB", false ).DateTimeFormat;

Related Solutions

C# – Given a DateTime object, how to get an ISO 8601 date in string format

Note to readers: Several commenters have pointed out some problems in this answer (related particularly to the first suggestion). Refer to the comments section for more information.

DateTime.UtcNow.ToString("yyyy-MM-ddTHH\\:mm\\:ss.fffffffzzz");

Using custom date-time formatting, this gives you a date similar to
2008-09-22T13:57:31.2311892-04:00.

Another way is:

DateTime.UtcNow.ToString("o");

which uses the standard "round-trip" style (ISO 8601) to give you
2008-09-22T14:01:54.9571247Z.

To get the specified format, you can use:

DateTime.UtcNow.ToString("yyyy-MM-ddTHH:mm:ssZ")

Mysql – How to set a default value for a MySQL Datetime column

IMPORTANT EDIT: It is now possible to achieve this with DATETIME fields since MySQL 5.6.5, take a look at the other post below...

Previous versions can't do that with DATETIME...

But you can do it with TIMESTAMP:

mysql> create table test (str varchar(32), ts TIMESTAMP DEFAULT CURRENT_TIMESTAMP);
Query OK, 0 rows affected (0.00 sec)

mysql> desc test;
+-------+-------------+------+-----+-------------------+-------+
| Field | Type        | Null | Key | Default           | Extra |
+-------+-------------+------+-----+-------------------+-------+
| str   | varchar(32) | YES  |     | NULL              |       | 
| ts    | timestamp   | NO   |     | CURRENT_TIMESTAMP |       | 
+-------+-------------+------+-----+-------------------+-------+
2 rows in set (0.00 sec)

mysql> insert into test (str) values ("demo");
Query OK, 1 row affected (0.00 sec)

mysql> select * from test;
+------+---------------------+
| str  | ts                  |
+------+---------------------+
| demo | 2008-10-03 22:59:52 | 
+------+---------------------+
1 row in set (0.00 sec)

mysql>

CAVEAT: IF you define a column with CURRENT_TIMESTAMP ON as default, you will need to ALWAYS specify a value for this column or the value will automatically reset itself to "now()" on update. This means that if you do not want the value to change, your UPDATE statement must contain "[your column name] = [your column name]" (or some other value) or the value will become "now()". Weird, but true. I am using 5.5.56-MariaDB

Best Solution

Related Solutions

C# – Given a DateTime object, how to get an ISO 8601 date in string format

Mysql – How to set a default value for a MySQL Datetime column

Related Question