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

show (value1,value2) in one column in sql

By -
declare @edition varchar(100)   select @edition = STUFF((SELECT  '/' + newspaperedition FROM ADVT_REQUEST INNER JOIN  NEWBILL ON ADVT_REQUEST.RO_CODE = NEWBILL.ROCODE    INNER JOIN MRADDRESS ON NEWBILL.NP_CODE = MRADDRESS.np_code WHERE New_ROCode = '1137/13/64/2021/71753/31/3'         FOR XML PATH('')), 1, 1, '')
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