Set field DateTime to show the date and time in the format dd/mm/yyyy hh:mm:ss

Question

This code gets the date from the table to show in a table for the user

using System; 
using System.Data; 
using System.Configuration; 
using System.Web; 
using System.Web.Security; 
using System.Collections; 
using System.Collections.Generic;
using System.Text;

namespace Form 
{
    public class RelUso
    {
        public DateTime Date { get; set; }
    }
    public RelUso()
    {
        atribuiValores(row);
    }
    public RelUso(DataRow row)
    {
        assignValues(row);
    }
    protected void assignValues(DataRow row)
    {
        this.Data = Convert.ToDateTime(row["Date"]);
    }
}

It gets the date how it is in the database yyyy-mm-dd hh:mm:ss. Can I do some method in the DateTime to change the formatting of the date to dd/mm/yyyy hh:mm:ss

The `DateTime` does not have a format - it is just a value. How it displays to the user depends on the culture. — Ňɏssa Pøngjǣrdenlarp, Jan 07 '15 at 16:21
possible duplicate of [convert datetime to date format dd/mm/yyyy](http://stackoverflow.com/questions/5050102/convert-datetime-to-date-format-dd-mm-yyyy) — PiotrWolkowski, Jan 07 '15 at 16:28

mhan0125 · Accepted Answer · 2015-01-07T18:36:35.850

4

You can convert the DateTime structure to string using the following code:

var dt = DateTime.Now;
string str = dt.ToString("yyyy-MM-dd hh:mm:ss"); //(For month use caps 'MM')

edited Jan 07 '15 at 18:36

answered Jan 07 '15 at 16:29

mhan0125

604
1
11
33

score 2 · Answer 2 · edited Jan 08 '15 at 07:15

2

Use

Convert.ToDateTime(row["Date"]).ToString("dd/MM/yyyy HH:mm:ss")

edited Jan 08 '15 at 07:15

Soner Gönül

97,193
102
206
364

answered Jan 07 '15 at 16:24

MyB

199
4

1

I put : Convert.ToDateTime(row["Date"]).ToString("dd/MM/yyyy HH:mm:ss");this.Data = Convert.ToDateTime(row["Data"]); But nothing has changed – jean cavalcante Jan 07 '15 at 16:36
the Date field should be a string. – MyB Jan 08 '15 at 10:47

Set field DateTime to show the date and time in the format dd/mm/yyyy hh:mm:ss

2 Answers2