Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, June 25, 2015 11:31 AM
Points: 367, Visits: 422
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: Yesterday @ 1:17 PM
Points: 32,157, Visits: 16,546
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 @ 3:47 AM
Points: 42,222, Visits: 38,979
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
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


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, June 25, 2015 11:31 AM
Points: 367, Visits: 422
+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


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Thursday, July 2, 2015 2:57 PM
Points: 14,244, Visits: 13,936
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