Loading

date time zones

satish kumar

12y1.2k

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

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Khan Abrar Ahmed12y ago
Hi please refer this links
http://blog.sqlauthority.com/2008/08/14/sql-server-get-date-time-in-any-format-udf-user-defined-functions/
http://msdn.microsoft.com/en-us/library/ms187928.aspx