Convert datetime to string in format HH:mm:ss in T-SQL

0 Comments

CONVERT(VARCHAR(8),GETDATE(),108) Result 14:12:30 Other examples print convert(varchar(30),getdate(),121) -- Result: 2011-05-09 12:04:31.883 print convert(varchar(30),getdate(),113) -- Result: 29 Apr 2011 13:41:23:327

Adding date and time to a log file path in SSIS 2005

0 Comments

Right click your log file connection, click on properties In the property windows click on Expressions > ConnectionString   Expression Add the expression: (DT_WSTR,1000) (   "C:\Temp\" +   RIGHT("0" + (DT_STR,4,1252) DATEPART("year",GETDATE()),4) +  …

Using XBMC on mine ASROCK 330 Pro

0 Comments

  Replacing the stock fans First thing I did was updating the bios to the latest version and replacing the stock fans by more silent fans, because this reduced the sound level significantly. I used…