Is there any way to added to the SQL Server wish list ?

YES!

Just send your feedback to sqlwish@microsoft.com and these feedbacks/ideas gathered this way is used to select features that go into new SQL Server version!

How to get GMT (Greenwich Mean Time) rather than current time in earlier version of SQL Server ?

In SQL Server 2000 only a new function introduced to get GMT

But, What about the earlier version of SQL Server 2000/Before SQL Server 2000 ?

Before SQL Server 2000
DECLARE @GMTTimeZone INT
EXEC MASTER.dbo.xp_regread
'HKEY_LOCAL_MACHINE',
'SYSTEM\CurrentControlSet\Control\TimeZoneInformation',
'ActiveTimeBias',
@GMTTimeZone OUT

SELECT DATEADD(MINUTE,@GMTTimeZone, GETDATE()) [ANCIENT METHOD]
GO


SQL Server 2000 onwards
SELECT GETUTCDATE() [GETUTCDATE()]
GO

Note: This method applies to all SQL Server versions