Convert SQL Date time format to String

Question

when reading SQl Date time field , only i can take the date with time ..how to get only date in to text box from Ajax or some method.

this is what i need to do

https://i.sstatic.net/n0fgG.jpg

that's how I'm taking the date to text box.

    protected void ddlBatch_SelectedIndexChanged(object sender, EventArgs e)
    {
        String strConnString = ConfigurationManager.ConnectionStrings["CBConnectionString"].ConnectionString;
        const String strQuery = "select ItemIdentityCode, Qty, PurchasingPrice, ExpireDate, DiscountRate, IssueMode,  Principle, Force from DEL_PurchasesLines where BatchNumber = @BatchNumber";
        SqlConnection conPR = new SqlConnection(strConnString);
        SqlCommand cmdPR = new SqlCommand();
        cmdPR.Parameters.AddWithValue("@BatchNumber", ddlBatch.SelectedItem.Value);
        cmdPR.CommandType = CommandType.Text;
        cmdPR.CommandText = strQuery;
        cmdPR.Connection = conPR;
        try
        {
            conPR.Open();
            SqlDataReader sdr = cmdPR.ExecuteReader();
            while (sdr.Read())
            {

                tHFExpiaryDate.Text = sdr["ExpireDate"].ToString();

            }
        }
        catch (Exception ex)
        {
            //throw ex;
        }

        finally
        {
            conPR.Close();
            conPR.Dispose();
        }
    }

Jon Skeet · Accepted Answer · 2013-10-02 11:02:24Z

9

Don't convert the raw value to a string in the first place - it should already be a DateTime:

DateTime date = (DateTime) dsr["ExpireDate"];

Then you can convert it into whatever format you're interested in:

// TODO: Consider specifying the culture too, or specify a standard pattern.
tHFExpiaryDate.Text = date.ToString("MM/d/yyyy");

It's important to separate the question of "How can I get the data from the database in an appropriate type?" from "How should I present the data to the user?"

edited Oct 2, 2013 at 11:02

answered Oct 2, 2013 at 10:55

Jon Skeet

1.5m893 gold badges9.3k silver badges9.3k bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Alessandro D'Andria Over a year ago

Just a side note for what I see the format should be "M/d/yyyy" (10/2/2013 as in the image).

Sadique · Accepted Answer · 2013-10-02 11:46:25Z

1

Try something like:

DateTime.ParseExact(sdr["ExpireDate"].ToString(), "MM/d/yyyy", CultureInfo.InvariantCulture)

In your sample:

tHFExpiaryDate.Text = DateTime.ParseExact( ((DateTime)dt.Rows[0][0]).ToString("MM/d/yyyy"), "MM/d/yyyy", System.Globalization.CultureInfo.CurrentCulture).ToString("MM/d/yyyy"));

edited Oct 2, 2013 at 11:46

answered Oct 2, 2013 at 10:52

Sadique

22.8k7 gold badges68 silver badges92 bronze badges

2 Comments

Dilan Wickramarathna Over a year ago

how to use this answer in my scenario.. can you explain please

Sadique Over a year ago

sdr["ExpireDate"] will be of type of object. Assuming your data is storing valid info we convert it to string, and parse it - finally we provide a format (like month first) it.

Learning · Accepted Answer · 2013-10-02 12:10:58Z

0

This always works for me

protected String getDate(string date)
{
    DateTime dDate;
    string sdate = null;
    if (!string.IsNullOrEmpty(date.ToString()))
    {
        dDate = DateTime.Parse(date.ToString());
        sdate = dDate.ToString("dd/MM/yyyy");
        sdate = dDate.ToLongDateString();
    }
    return sdate;
}

Other date format example http://www.dotnetperls.com/datetime-format

answered Oct 2, 2013 at 12:10

Learning

20.1k44 gold badges193 silver badges400 bronze badges

1 Comment

Dilan Wickramarathna Over a year ago

Thank you @KnowledgeSeeker really helpful point ,,, including the link .. :)

Collectives™ on Stack Overflow

Convert SQL Date time format to String

3 Answers 3

1 Comment

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related