0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for people looking to improve their interpersonal communication skills

declare @time table (Zone varchar(200),Times varchar(200))

declare @toronto datetime,@india datetime,@hongkong datetime

insert @time
SELECT 'India    -',dateadd(mi,330,getdate())
insert @time
SELECT 'HongKong -',dateadd(mi,480,getdate())
insert @time
SELECT 'Canada   -',dateadd(mi,-240,getdate())


select Zone+' '+Times Time from @time

fork query

edited jul 14

created jul 14 anonymous