Код

9,6))/10000,cast(left(j.date_time_iddoc,8) as datetime)),120),8) as ВремяДок 

да вроде не ругается, а должно?

Код

CREATE PROCEDURE [Convert36To10] @Res36 CHAR(9), @Deci INT OUTPUT AS
SET NOCOUNT ON
DECLARE @j INT
DECLARE @Arr36 CHAR(36)
SELECT @Arr36 = '0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ'
SELECT @Deci = 0
SELECT @j = 1
while @j <= LEN(LTRIM(RTRIM(@Res36)))
begin
if @j <> 1
SELECT @Deci = @Deci*36
SELECT @Deci = @Deci + CHARINDEX(SUBSTRING(LTRIM(RTRIM(@Res36)), @j,1),@Arr36) -1
SELECT @j = @j+1
End

 

Код

select top 1
9,6))/10000,cast(left(j.date_time_iddoc,8) as datetime)),120),8) as ВремяДок
from _1sjourn as j
 

Код

Invalid object name 'dbo.Convert36To10'. 

Код

IF object_id('ConvSyst10') is null
exec('CREATE FUNCTION ConvSyst10(@num varchar(99), @syst int)
RETURNS bigint AS
BEGIN
declare @i bigint,@c int
SELECT @i=0,@num = UPPER(@num)
while @num<>'''' select @c=ascii(LEFT(@num,1)),
@i=case when @c>57 then @c-55 else @c-48 end *power(@syst,len(@num)-1) +@i,
@num=right(@num,len(@num)-1)
return @i END')
 

Код

select
Convert(Varchar,DATEADD(Millisecond, dbo.ConvSyst10(SUBSTRING(Жур.DATE_TIME_IDDOC,9,6), 36)/10, LEFT(Жур.DATE_TIME_IDDOC,8)),8) as Время
from _1sjourn as Жур