Category "timezone"

How to set MySQL time?

I want to do some testing without changing records' timestamps nor queries. My queries have NOW() in them, and I don't want to wait. So is there a way to tempor

how do you sort time zones please?

Hi I'm using the following to populate a drop down list. I would prefer the list was sorted alphabetically on ID rather than the default. ReadOnlyCollection zo

How to change Date and Time settings on Google Cloud Instance?

I am trying to change Date and time settings to UTC+10 Canberra,Sydney,Melbourne on the instance but it always keep rolling back to UTC+00 Monrovio, Reykjavik.

How to work with gas days in a C# project?

A gas day is defined as a time range of 24 hours which starts at 5:00 UTC and ends at 5:00 UTC of the following day during the European standard time. During th

django settings default time zone

here is a question i can use django time zone for utc and it worked fine but when i switch the default time zone to 'Asia/Tehran' it wont work and i get the err

Postgres Sql - How to apply Offset on Timestamp

My offset-date-time object I store in the DB with 2 columns, one timestamp(UTC) column and another corresponding offset. For example, if I get: 2017-05-01T16:16

Getting the start of the day in a different timezone

I have a Date. It is in the local timezone. I want a new Date that is at the beginning of the dayin a different timezone. Here are some things I do not want: A

Vue.js How to make a select with timeZones

I want to have a select with Vue.js because I want to be able to select de different timeZones of the world My first question would be: What is the best library

Set different timezone for each deployable in tomcat

I have a web project which creates 2 separate deployables(.war files). I deployed both in single tomcat, and when I change the JVM timezone in a beanFactoryPost

using time zone in pandas to_datetime

I have time from epochs timestamps I use data.Time_req = pd.to_datetime(data.Time_req) But I get UTC time, I need +5:30 from the given time. How do I tell panda

Identifying time zones in ISO 8601

No, I'm not talking about zone offsets --- those can vary during the year for a region based on e.g. DST. I'm talking about the actual time zones maintained by

Convert date/time in email from UTC to a user's local timezone

I work on an application that sends out automated emails notifying users of when an event will end, e.g. Hey, That event you're interested in will end on 2021-

Linux Time Zone Warning

I'd like to know the meaning of the alert message that occurs in the Linux time zone. timedatectl Warning: Ignoring the TZ variable. Reading the system's time

How to convert current datetime into given timezone and store in MongoDB & fetch in DD-MM-YYYY HH:mm format?

My local time is 'Asia/Kolkata.' And I have to convert the current DateTime into 'Pacific/Auckland' and store it into MongoDB And on fetch I have to format this

get time for timezone

I'm hurting my head again this : On postgresql, I would like to get the local time for a given timezone. So, at 15:45 GMT, I want 16:45 for +01:00, but I can't

Time Zone in Kubernetes Pods Using Environment Variable

I am trying to update my pod time to Asia/Kolkata zone as per kubernetes timezone in POD with command and argument. However, the time still remains the same UTC

How can I change Apache Cassandra's default time zone?

I need to run a Cassandra instance on Windows... Don't ask why... Anyway the issue is that I have time stamp columns that show datetime in PST time zone but I

PostgreSQL timezone takes Windows OS timezone automatically

While installing Postgresql DB 13.0-1 x64 on Windows, if I comment the "timezone" key on postgresql.conf file then "show timezone" sql query gives me "GMT". How

Getting Exchange Server's users timezone

I'm having a bit of a problem. I am working on a small outlook plugin(in c#) with the following functions(very simplified): Get all of the users from Exchange

Resolving AmbiguousTimeError from Django's make_aware

I have a code as follows: from django.utils.timezone import get_current_timezone, make_aware make_aware(some_datetime, get_current_timezone()) The make_awar