Monday 3 December 2012

Datediff with sql server

Date-
1.       select DATEDIFF(MILLISECOND ,GETDATE()-1,GETDATE()) as milisecond


Time-

1.       select right(convert(varchar(30),getdate(),121),12)
                             outpur-- 15:02:24.3424398

2.       SELECT CONVERT(VARCHAR(16), SYSDATETIME(), 14)

                              outpur-- 15:02:24.3424398

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