SQL Code - Worldwide Clock - SQL Server Q&A from the SQL Server Central community

SQL Code - Worldwide Clock

Hi All, I have been all over google searches etc and just can't find out how to produce the code that would show me the time for preset countries that refreshes in real time.

I currently have the following code that sort of does the job but just won't automatically fresh;

SELECT GETDATE() 'GMT', 
			DATEADD(hour,-6,GETDATE()) 'Provo',
			DATEADD(hour,+3,GETDATE()) 'Bucharest',
			DATEADD(MI,330,GETDATE()) 'India',
			DATEADD(hour,+8,GETDATE()) 'China'

Does anyone know how better to write this??

Anything would be massively appreciated,

Thanks,