Timezones for date columns in msdb.dbo.sysmail_mailitems
There are a few date columns in msdb.dbo.sysmail_mailitems.
They are
send_request_date
sent_date
last_mod_date
When working with these dates it is good to know what timezone they are stored in. MS SQL Server doesn't store timezone information in the datetime datatype. However, I have determined that these three date fields are stored in the timezone of the MS SQL Server.
In other words, if you send an email you will see that these dates are close to the time that you get when you do:
SELECT GetDate()
1 comment:
This is a great post. I like this topic.This site has lots of advantage.I found many interesting things from this site. It helps me in many ways.Thanks for posting.
Biotech Internships | internships for cse students | web designing course in chennai | it internships | electrical engineering internships | internship for bcom students | python training in chennai | web development internship | internship for bba students | internship for 1st year engineering students
Post a Comment