Set the date format in the gridview

 

Because the datetime data retrieved from the database all has time, and many times only need to display the Time of the date.

Previously, the formatted date was deleted using a template column and a regular expression. Today, I saw a simpler method on the Internet, that is, to bind a column directly, set the dataformatstring and htmlencode attributes as follows:

<Asp: boundfield headertext = "expected transaction date" datafield = "fcbargaindate" dataformatstring = "{0: yyyy-mm-dd}" htmlencode = "false"/>

In fact, I used to think about using dataformatstring, but I didn't expect to set htmlencode, so I never succeeded. I don't know why I should set it like this. Fortunately, no HTML tags appear in the Date Field ......

The format string given on msdn:

Number and currency format:

After the specified format symbol, you can specify the number of digits to be displayed in decimal places. For example, if the original data is "1.56" and the format is set to {0: N1}, the output is "1.5 」. The common numeric format is shown in the following table:

Format String input result

"{0: c}" 12345.6789 $12,345.68

"{0: c}"-12345.6789 ($12,345.68)

"{0: d}" 12345 12345

"{0: D8}" 12345 00012345

"{0: e}" 12345.6789 1234568e + 004

"{0: E10 }" 12345.6789 1.2345678900e + 004

"{0: F }" 12345.6789 12345.68

"{0: F0 }" 12345.6789 12346

"{0: g}" 12345.6789 12345.6789

"{0: G7}" 123456789 1.234568e8

"{0: n}" 12345.6789 12,345.68

"{0: N4}" 123456789 123,456,789.0000

"Total: {0: c}" 12345.6789 total: $12345.68

Common Date and Time formats:

Format description output format

D. Simplified Date Format: mm/DD/YYYY

D detailed Date Format: dddd, Mmmm DD, yyyy

F full format (long date + short time) dddd, Mmmm DD, yyyy hh: mm

F

Complete Date and Time Format

(Long date + long time)

Dddd, Mmmm DD, yyyy hh: mm: SS

G General Format (short date + short time) mm/DD/YYYY hh: mm

G General Format (short date + long time) mm/DD/YYYY hh: mm: SS

M, M month/day format mmmm dd

S moderate Date and Time Format: yyyy-mm-dd hh: mm: SS

T simplified time format hh: mm

T detailed time format hh: mm: SS