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: Wednesday, April 09, 2014 9:29 AM
Points: 214, Visits: 276
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 @ 10:15 AM
Points: 32,779, Visits: 14,938
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


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 6:58 AM
Points: 1,242, Visits: 1,385
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 @ 7:46 AM
Points: 41,528, Visits: 34,444
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


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 6:58 AM
Points: 1,242, Visits: 1,385
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: Wednesday, April 09, 2014 9:29 AM
Points: 214, Visits: 276
+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: Today @ 10:18 AM
Points: 11,982, Visits: 11,003
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