0

heys guys, i want to store the date in IST format in sql server 2008, my issue is i have an error log table, whenever there is any problem in my website, it save the entry in database, now what i want to do is, i want to store the date in IST format, so that i can come to know the occurance of the error if my client complains for any.. but i dont get an option to convert date in IST format before saving in sqlserver.

Abbas
  • 4,948
  • 31
  • 95
  • 161

1 Answers1

0

Dates (datetimes) are stored as binary; the format is only an issue when you display (or output) a date as text.

You can format a date using CONVERT

Also see:

Mitch Wheat
  • 295,962
  • 43
  • 465
  • 541
  • thanks for your reply, can you tell me is there anything i can do in .net to change the time format from EST to IST, i know its against my question within the thread, but can you please help me. i needed this done urgently. thanks – Abbas May 14 '11 at 03:01
  • http://stackoverflow.com/questions/24797/effectively-converting-dates-between-utc-and-local-ie-pst-time-in-sql-2005#25073 – JStead May 14 '11 at 11:13