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

0

Please login or register to vote for this query.

(click on this box to dismiss)

Interpersonal Skills

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

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results