Hi,

Please check the following code. This may help you.

------code

declare @time table (id int identity (1,1),v_time time,v_date date)

insert into @time

SELECT

convert(time,CONVERT(VARCHAR(8),GETDATE(),108)) AS HourMinuteSecond,

CONVERT(VARCHAR(10),GETDATE(),101) AS DateOnly

from msdb.INFORMATION_SCHEMA.COLUMNS

update @time set v_time = DATEADD(mi,15*id,v_time),v_date = DATEADD(day,id/97,v_date)

select * from @time where v_date = CONVERT(VARCHAR(10),GETDATE(),101)

------ end of code

Regards

Siva Kumar