Sunday 18 March 2018

Convert Datetime in AM/PM format using sql query

/////////////

select CONVERT(VARCHAR(12), getdate(), 103) + ' ' + LTRIM(RIGHT(CONVERT(CHAR(20), getdate(), 22), 11))

No comments:

Post a Comment

Excel Sort values in ascending order using function TEXTJOIN

 Excel ::  Text ::  1,3,5,2,9,5,11 Result :: 1,2,3,5,5,9,11 Formula ::     TEXTJOIN ( ",",1,SORT(MID(SUBSTITUTE( A1 ,","...