Show datetime value into DD/MM/YYYY

By -

CONVERT(varchar(103),SUBMISSION_DATE,103) AS SUBMISSION_DATE

Comments

Post a Comment

Popular posts from this blog

How to change value on selection of dropdown list control in datagid

By -
How to change value on selection of dropdown list control in datagrid. // drpmodify is dropdown list. protected void drpmodify_SelectedIndexChanged(object sender, EventArgs e) { DropDownList list = (DropDownList)sender; TableCell cell = list.Parent as TableCell; DataGridItem item = cell.Parent as DataGridItem; DropDownList index = (DropDownList)item.Cells[10].FindControl("drpmodify"); DropDownList drpmodify12 = null; drpmodify12 = (DropDownList)index; TextBox txtupdate = null; txtupdate = (TextBox)item.Cells[11].FindControl("TxtUpdate"); if ((drpmodify12.SelectedValue == "N") || (drpmodify12.SelectedValue == "M") || (drpmodify12.SelectedValue == "NE") || (drpmodify12.SelectedValue == "DU") || (drpmodify12.SelectedValue == "D") || (drpmodify12.SelectedValue == "I")) { txtupdate.Text = ""...
Read more
By -
Solution to error - String was not recognized as a valid DateTime.                                                       or  Conversion from string "29/04/2020" to type 'Date' is not valid Save date in SQL DB Dim requestdate As String             requestdate = DateTime.ParseExact(txtfrom.Text, "dd/MM/yyyy", Nothing).ToString("yyyy/MM/dd") comm.Parameters.AddWithValue("@req_date", requestdate)
Read more

Convert Date Format

By -
public static DateTime ConvertDateFormat (string str) { int dd, mm, yy; string[] strarr = new string[3]; strarr = str.Split(new char[] { '/' }, str.Length); dd = Int32.Parse(strarr[0]); mm = Int32.Parse(strarr [1]); yy = Int32.Parse(strarr[2]); DateTime dt = new DateTime(yy,mm,dd); return (dt); }
Read more