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
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: 2 days ago @ 10:24 AM
Points: 295, Visits: 342
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 @ 3:05 PM
Points: 31,284, Visits: 15,750
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


UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Tuesday, November 25, 2014 1:28 PM
Points: 1,461, Visits: 1,752
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 @ 5:17 AM
Points: 40,450, Visits: 36,905
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 2008, 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


UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Tuesday, November 25, 2014 1:28 PM
Points: 1,461, Visits: 1,752
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 Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: 2 days ago @ 10:24 AM
Points: 295, Visits: 342
+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: 2 days ago @ 9:10 AM
Points: 13,230, Visits: 12,709
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