Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

What is the time zone for the datetime stamp for posts? Expand / Collapse
Author
Message
Posted Wednesday, September 25, 2013 10:53 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: 2 days ago @ 3:59 PM
Points: 432, Visits: 499
I'm curious as to what the time zone is that generates the datetime stamp for forum posts. Or is it simply a
GETUTCDATE()

?
Post #1498490
Posted Wednesday, September 25, 2013 11:09 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 3:31 PM
Points: 34,183, Visits: 18,334
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.






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1498499
Posted Wednesday, September 25, 2013 11:14 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Thursday, January 15, 2015 5:53 AM
Points: 1,539, Visits: 1,820
It's definitely not local time...looks like UTC to me.
Post #1498501
Posted Wednesday, September 25, 2013 11:16 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 12:59 PM
Points: 45,327, Visits: 43,557
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

Post #1498503
Posted Wednesday, September 25, 2013 11:20 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Thursday, January 15, 2015 5:53 AM
Points: 1,539, Visits: 1,820
Ha...it occurs to me now that I have never really browsed around the control panel at all. Thanks!
Post #1498504
Posted Wednesday, September 25, 2013 12:16 PM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: 2 days ago @ 3:59 PM
Points: 432, Visits: 499
+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.
Post #1498529
Posted Wednesday, September 25, 2013 1:42 PM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 2:03 PM
Points: 15,996, Visits: 16,555
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.

_______________________________________________________________

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 Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
Post #1498574
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse