hi everyone...
i need to have the date and time irrespective to the system time and date.actually when we give a query with getdate() the system time is stored in database but i need irrespective to that even i tried with getutcdate() it just shows less than 5:30 hrs than system time but when i change my system time and tried that it shows as per my system time........that should get the exact utc irrespective to system time.Also i need it in indian standard time