What is the time zone for the datetime stamp for posts?

Question

What is the time zone for the datetime stamp for posts?

logitestus

SSCrazy

Points: 2928
More actions
September 25, 2013 at 10:53 am

#299145

I'm curious as to what the time zone is that generates the datetime stamp for forum posts. Or is it simply a GETUTCDATE()?

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Steve Jones - SSC Editor SSC Guru Points: 736063 More actions · Answer 1

It should be local time. It is possible it's showing the server time, which I believe is set to my time, US Mountain time.

batgirl SSCarpal Tunnel Points: 4979 More actions · Answer 2

It's definitely not local time...looks like UTC to me.

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 3

It's whatever you've got it set to in the forum settings (Control Panel -> Forum Settings). Mine is in Central African Time.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

batgirl SSCarpal Tunnel Points: 4979 More actions · Answer 4

Ha...it occurs to me now that I have never really browsed around the control panel at all. Thanks!

logitestus SSCrazy Points: 2928 More actions · Answer 5

+1 to batgirl's comment. Thanks for the heads up.

EDIT: I wonder why my time zone was set to Western Europe? Or a better phrase might be: what possessed me to set it up to that time zone? I think I need to stop using Jeff Moden's beer popsicles[/url].

Sean Lange SSC Guru Points: 286590 More actions · Answer 6

ROFL. I never realized that option was there either. I have always just completely ignored the time of the post. Apparently I was set to central Europe. That is bit off from Central time. :hehe:

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/