SQL Timezone

I just moved my website to DiscountASP, and noticed that the times on my website are now reported as PMT (-7). This makes sense since your servers are on west coast (I'm EST).

I've corrected for the time difference, however, I'm confused by the fact that the raw datetime data in my SQL DB is actually in UTC. I'm not aware of a setting in SQL Server that allows for times to be stored in UTC.

Is the SQL Server on GMT time which would of course save datetimes as UTC or am I missing something?

 

Figured it out. I was only looking at ASP Membership datetime data which is converted to UTC by the NET framework. All my other data (non ASP Membership) is all stored as PMT as expected.

Probably should convert all my data to UTC also so that if my database is ever moved again to another server in another timezone datetimes will be consistent...

Seems to me like it might be better if all public servers defaulted to GMT timezone so that datetimes are always reported in UTC regardless of physical location. Just a thought...