Declare @mybigint  bigint
set @mybigint = 
convert(bigint,replace(replace(replace(replace(convert(char(23), getdate(), 121),'-',''),':',''),'.',''),' ',''))
print @mybigint

     Jul 13  

Sometimes this is me

Declare @mybigint  bigint
set @mybigint = 
convert(bigint,replace(replace(replace(replace(convert(char(23), getdate(), 121),'-',''),':',''),'.',''),' ',''))
print @mybigint


declare @mychar char(23)
Select @mychar = convert(char(23), @mybigint)
Select @mychar = substring(@mychar,1,4) + '-' + substring(@mychar,5,2)  + '-' + substring(@mychar,7,2) + ' ' 
                + substring(@mychar,9,2) + ':' + substring(@mychar,11,2) + ':' + substring(@mychar,13,2) 
                + '.'+ substring(@mychar,15,3)

declare @mydatetime datetime
set @mydatetime = convert(datetime,@mychar,121)
print convert(char(23),@mydatetime,121)

     Jul 13  

Sometimes this is me

Declare @mybigint  bigint
set @mybigint = 1196100822809 

print @mybigint

declare @mychar char(23)
declare @mycharwrk char(23)
Select @mychar = convert(char(23), @mybigint )
print cast(reverse(substring(ltrim(reverse(@mychar)), 10,10)) as int)

select @mycharwrk = convert(char(10),dateadd(dd,cast(reverse(substring(ltrim(reverse(@mychar)), 10,10)) as int),'1900-01-01'),121)
				 + ' ' + reverse(substring(ltrim(reverse(@mychar)), 8,2))
				 + ':' + reverse(substring(ltrim(reverse(@mychar)), 6,2))
				 + ':' + reverse(substring(ltrim(reverse(@mychar)), 4,2))
				 + '.' + reverse(substring(ltrim(reverse(@mychar)), 1,3))
 
print @mycharwrk

declare @mydatetime datetime
set @mydatetime = convert(datetime,@mycharwrk,121)
print convert(char(23),@mydatetime,121)

Print 'Did you notice the change in ms ?? !! '

     Jul 13  

Sometimes this is me