Как сделать CONVERT из FORMAT DATE with TIME только TIME ?

Но мне надо format hh:mi:ss ?
Datepart prinimaet tolko 1 znachenie .

A chto nibud v odnu strochku net ?
Thanks vsem za otveti

MAXX spasibo.No mne nado vse v odnom formate(ne v 3 colonkax) ?

Vsem spasibo , v tom chisle i 3JIA9I CyKA !!!!!!!!!!!!!!!!111

U menya est column s 30.07.2002 18:19:22 (datetime format)
Ya dolzen posle check perenesti eto v druguy table , no
tolko v format TIME

Vse rabotaet .
Vsem OGROOOOOOOOOOOOOOOOOOOOOmnoe spasibo za pomoz .!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

Ya novichek v SQL .
Chto takoe BOL ?

Big Sorry.
Ya pitaus izmenit parametr , no nichego ne poluchaetsya.

USE Almond

GO
DECLARE @SubsAccID_s int ,@SpecialBD_s datetime, @SpecialED_s datetime ,@HolidayBD_s datetime ,@HolidayED_s datetime , @ScheduleOpen_s datetime , @ScheduleClose_s datetime

DECLARE vSubsc_cursor CURSOR FOR
SELECT * FROM vSubsc


OPEN vSubsc_cursor

-- Perform the first fetch.
FETCH NEXT FROM vSubsc_cursor
INTO @SubsAccID_s ,@SpecialBD_s , @SpecialED_s,@HolidayBD_s ,@HolidayED_s, @ScheduleOpen_s , @ScheduleClose_s

-- Check @@FETCH_STATUS to see if there are any more rows to fetch.
WHILE @@FETCH_STATUS = 0
BEGIN
-- This is executed as long as the previous fetch succeeds.
IF (@SpecialBD_s IS not NULL )
BEGIN
INSERT INTO ScheduleDay
(AccountID,BeginingDate,EndingDate)
VALUES (@SubsAccID_s,convert(varchar, @SpecialBD_s, 108),@SpecialED_s)
END
ELSE
IF (@HolidayBD_s IS not NULL )
BEGIN

INSERT INTO ScheduleDay
(AccountID,BeginingDate,EndingDate)
VALUES (@SubsAccID_s,@HolidayBD_s,@HolidayED_s)
END
ELSE
IF (@ScheduleOpen_s IS not NULL )
BEGIN

INSERT INTO ScheduleDay
(AccountID,BeginingDate,EndingDate)
VALUES (@SubsAccID_s,@ScheduleOpen_s ,@ScheduleClose_s )
END

FETCH NEXT FROM vSubsc_cursor
INTO @SubsAccID_s ,@SpecialBD_s , @SpecialED_s,@HolidayBD_s ,@HolidayED_s, @ScheduleOpen_s , @ScheduleClose_s

END

CLOSE vSubsc_cursor
DEALLOCATE vSubsc_cursor
GO

V IF (@SpecialBD_s IS not NULL )
mne nado convert @SpecialBD_s(datetime), au menya ne vixodit.
Podskazite please.