how about this:
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)
Check out "convert" in bol
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me