Before the new Google Drive UI I was able to change my default timezone using the following:   However, on the new interface I can't find the option to do it. So every spreadsheet I create I have to go and change the time zone.   I've changed the calendar timezone, but only affects the calendar, changed languages to another country and back to see if it would trigger the timezone change. It actually accepts the country I am right now as default, but it still is on the timezone of the country I've previously lived in.
121074
It appears that I have to proactively select the timezone I'm in to Google Drive so that they display correctly. Is there a way I can push this setting to all users within the organization?
87792
I asked  yesterday, approximately 18 hours ago ("2011-12-13 20:24:03Z" according to the hover text), and it's still being displayed as "today".  I assume the "Z" in the timestamp refers to Zulu time, so I , and the date (2011-12-14) differs from the timestamp on the question.  I don't pretend to understand all of the complexities when converting time zones, but I thought it was strange enough to report. If it matters at all, I'm in US-Eastern.
65271
I want to check the time      Eastern Daylight Time   Time zone in Washington, DC, USA (GMT-4)   Thursday, May 9, 2019, 8:11 PM   However,   $ TZ="EDT" date Fri May 10 00:12:25 EDT 2019   "EST" works properly  $ TZ="EST" date Thu May  9 19:13:11 EST 2019   What's the problem?
40349
Using Ubuntu 16.04. I like Krusader, but can't figure out how it is possible to change date/time format for the Modified column. I truied to change system regional settings, but Krusader ignores them (while, e.g., Midnight Commander uses system settings). Switching application language (in Help menu) also does not affect the date/time format. I like the 24-hour format, not PM/AM, and I may prefer even to hide time, and leave only date. Is that possible in Krusader?  The other post is of no help, as there is no even such file in mys systems as ~/.kde/env/setlocale.sh
51934
A few months ago I was introduced to the new  type and was glad 's flaws with regard to time zones were finally taken care of.  However, I was left wondering if there were any overhead or problems that could occur from using this new type.  I work on a multi-locale web application. Does anyone know of anything that could sway me from just using it for all my date/time work? Is there a window for abuse here?  Reference:
109269
I need to change cell dates with a general format (mm/dd/yy) to a text format for uploading to Peoplesoft. However I must retain the mm/dd/yy. When I change the cell from general format to text format it then changes the date to a serial number date such as 41982 etc. I don't want the serial number date. It must remain a text format cell with mm/dd/yy or mm/dd/yyyy etc.
57923
I wanted to use this, but I don't know if it's actually valid in English:     The specified date is invalid.It points to a non-existing day.   I'm not a native speaker, and I just want to say that the input points to a date that does not exist, like 30th February.
98015
I've been working on a shared Google spreadsheet on Google Drive. The document has different sheets with a "Last Modified Date" Cell. I found an script for this to be auto-filled searching here:  function onEdit() {   var s = SpreadsheetApp.getActiveSheet();   var r = s.getActiveCell();   if( r.getColumn() != 2 ) { //checks the column     var row = r.getRow();     var time = new Date();     time = Utilities.formatDate(time, "GMT-08:00", "MM/DD/yy, hh:mm:ss");     SpreadsheetApp.getActiveSheet().getRange('B' + row.toString()).setValue(time);   }; };   The script works perfectly, I just changed the column and it worked! The thing is, I need to apply this script to every sheet but the first one. How can I deactivate the use of the script in the first sheet?
81559
Unfortunately, as a new user I am not allowed to comment. This is why I need to do a new post regarding to this topic:   This is my code in Google Sheets Script:  function onEdit(e) {   if (e.range.getSheet().getSheetName() == 'Tabellenblatt1' &amp;&amp; e.range.getColumn() == 1) {     e.range.offset(0,1).setValue(new Date());   } }   It works perfectly when I enter data in cell 1 manually, but when data is added via API (in this case when data is added via Zapier) it does not work. Anybody can give me a hint why?
116436
I have a sqlite (v3) table with this column definition:  "timestamp" DATETIME DEFAULT CURRENT_TIMESTAMP   The server that this database lives on is in the CST time zone.  When I insert into my table without including the timestamp column, sqlite automatically populates that field with the current timestamp in GMT, not CST.  Is there a way to modify my insert statement to force the stored timestamp to be in CST?  On the other hand, it is probably better to store it in GMT (in case the database gets moved to a different timezone, for example), so is there a way I can modify my select SQL to convert the stored timestamp to CST when I extract it from the table?
11596
I often move between 2 time zones, and expect my Windows 7 laptop to somehow automatically change the system time, being spoiled by the same feature on my cell phone. I always assumed that desktop O/Ses simply did not do this, but I was shocked yesterday when I noticed that OSX on the MacBook actually does this!  Does anybody know of any utilities that does this on Windows, specifically Windows 7? There has to be something out there?
24360
I don't understand the difference between these two columns. America/Chicago timezone is UTC-6, so I expect both to return the same result:  select timezone('America/Chicago', '2017-01-01 12:00:00'::TIMESTAMP AT TIME ZONE 'UTC'),        timezone('UTC-6'          , '2017-01-01 12:00:00'::TIMESTAMP AT TIME ZONE 'UTC');   However, the result is:  2017-01-01 06:00:00 | 2017-01-01 18:00:00   Also, this behavior is highly awkward,  SELECT '1:00 -1'::time with time zone AT TIME ZONE '-1';    timezone    -------------  03:00:00+01   Can anyone explain this?
64277
Just curious as to what the reasoning behind making the time stamps for the questions and answers in UTC instead of localizing the time for the client.  I do realize it's easier to store the value in UTC.  But, I would guess most of us think in local time and showing the date and time of the post isn't as meaningful if it's in UTC, having to do a conversion each time we see it.  I think it would be more useful and intuitive if it showed "answered Jul 2 at 15:38 EST" where EST is the viewer's local time zone.  It's possible I'm just not Skeet enough to think in Coordinated Universal Time.  (Skeet is an adjective as well as a verb, right?)    EDIT: As noted by me and others, perhaps defaulting to UTC, but allowing a user to select a different timezone in their profile would be a reasonable request.
101677
I'd really like a user option to show all dates as yyyy-mm-dd HH:mm after the 2 day mark. I find the existing non-standard semi-verbose American Mon DD 'YY style date to be ugly and difficult to parse.  I am not asking for anything complicated here, just a simple user option to show the date and time in the international ISO 8601 format across the board. Since it's already in the tooltip everywhere, it should be a simple change to optionally show it in the page body for those users who want it.  Secondarily, if it's not too difficult, I'd very preferably like to see date &amp; times in my local time, rather than the UTC time as is currently shown used. It seems to make much more sense to me for see a question "asked 2014-02-04 10:19" as being my local time - I don't know what UTC is without using a converter (in this the before-2-days "asked 6 hours ago" is quite good).  (Re-raising this feature-request at the explicit behest of moderator Anna Lear; please don't close as a duplicate).
83136
The best I can come up with for now is this monstrosity:  &gt;&gt;&gt; datetime.utcnow() \ ...   .replace(tzinfo=pytz.UTC) \ ...   .astimezone(pytz.timezone("Australia/Melbourne")) \ ...   .replace(hour=0,minute=0,second=0,microsecond=0) \ ...   .astimezone(pytz.UTC) \ ...   .replace(tzinfo=None) datetime.datetime(2008, 12, 16, 13, 0)   I.e., in English, get the current time (in UTC), convert it to some other timezone, set the time to midnight, then convert back to UTC.  I'm not just using now() or localtime() as that would use the server's timezone, not the user's timezone.  I can't help feeling I'm missing something, any ideas?
67823
I have created a field_time_zone field for the Article content type. I want to set the allowed values for that field to the values returned from system_time_zones(). For this, I implemented hook_form_alter() using the following code. $zones = system_time_zones(); $entityManager = \Drupal::service('entity_field.manager'); $fields = $entityManager-&gt;getFieldStorageDefinitions('node', 'local_market'); $options = options_allowed_values($fields['field_time_zone']);  if(empty($options)) { $options =  $zones; $form['field_time_zone']['widget']['#options'] = $options; }  The code adds the desired values, but the node cannot be saved, as it throws the following error.  The value you selected is not a valid choice.  How can I set the allowed values for a text (list) field?
110548
Is it possible to customize data (or date-time) format in Windows (I am using Windows&nbsp;XP)?  The current format which is followed by the OS [to show date-modified, etc.] is MM/DD/YYYY or M/D/YYYY, whereas I have been comfortable with DD/MM/YYYY or D/M/YYYY format. I am finding it hard to refer Date-modified [which I use often] of files and folders.