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

Difference between Byte and Char in Oracle

By -
If you define the field as VARCHAR2(11 BYTE), Oracle will allocate 11 bytes for storage, but you may not actually be able to store 11 characters in the field, because some of them take more than one byte to store, e.g. non-English characters. By defining the field as VARCHAR2(11 CHAR) you tell Oracle to allocate enough space to store 11 characters, no matter how many bytes it takes to store each one. I believe that in Oracle 10g, 3 bytes per character were used.
Read more

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