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()
No comments:
Post a Comment