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

How to highlight selected text in notepad++

  –> To highlight a block of code in Notepad++, please do the following steps step-1  :- Select the required text. step-2  :- Right click...