Friday, 1 February 2019

Sql datetime in a single string or integer(int 64 bit)

///////////////////// Sql


SELECT replace(replace(replace(convert(varchar, getdate(), 120),':',''),'-',''),' ','')

/////////////////// result


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...