satish kumar

satish kumar

  • NA
  • 8
  • 7.9k

date time zones

Aug 12 2014 8:06 AM
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 

Answers (1)