Skip to content
DbaFix
Just share answer and question for fixing database problem
MENU
  • HOME

Tag: timezone

E. Australia Standard Time appears to be one hour early?

By adminPosted on April 27, 2023

Question : I am trying to learn more about the sys.time_zone_info table. It all seems intuitive except for the E. […]

How should query with timezone for timestamp

By adminPosted on April 27, 2023

Question : We saved the timestamp with UTC. However, we would like to choose user to their own time zone. […]

Postgres streaming replication between hosts with different timezone

By adminPosted on April 23, 2023

Question : I am running Postgres 9.1 on Windows 2012 servers. I am using postgres’s streaming replication to replicate data […]

Why is AT TIME ZONE nondeterministic?

By adminPosted on April 2, 2023

Question : SQL Server 2016’s AT TIME ZONE appears to be nondeterministic. However, I haven’t been able to find documentation […]

Filter column by records matching a timezone in Postgres

By adminPosted on March 3, 2023

Question : I want to check whether any rows in my column (TIMESTAMP WITH TIME ZONE) are not stored using […]

mysqldump between servers with different timezones (tz-utc)

By adminPosted on February 26, 2023

Question : If I am moving databases between servers datetime/timestamp fields with different timezones; I have been doing: mysqldump –tz-utc=false […]

MySQL Timezone Resets after exiting server

By adminPosted on February 25, 2023

Question : I am running this code to set my database’s timezone: set time_zone = “US/Eastern” This successfully changes the […]

Preserving timezones explicitly in postgres

By adminPosted on February 7, 2023

Question : I’ve been doing quite some research on different ways of ‘seeing’ time and how to properly map it […]

Postgres automatic insert time stamp with time zone (india) [closed]

By adminPosted on January 20, 2023

Question : Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? […]

What is a valid use case for using TIME WITH TIME ZONE?

By adminPosted on January 14, 2023

Question : Along the lines of this related question: What is a valid use case for using TIMESTAMP WITHOUT TIME […]

  • 1
  • 2
  • 3
  • …
  • 7

Recent Posts

  • Improve reading speed of MySQL table storing stock prices (100 Mil. entries)
  • Adding sql users via linked servers
  • Postgres – caching of recently inserted data?
  • Does Oracle randomly switch execution plans to check if there is a better solution?
  • Cannot INSERT into database on a shared server
  • Simple query with a single join very slow
  • How to replicate and sync MongoDB localhost to a remote server using replica set
  • How can I increase performance for select in select statement
  • Optimize UNION query in MySQL
  • Mysql Performance tuning for myisam tables.
  • Get-ClusterParameter Not Returning Expected Results
  • SQL Server Extended Events to Capture Objects access by a User [duplicate]
  • Execution time of triggers fired when a procedure is executed in postgresql
  • Efficient query to get last row group by multiple columns
  • How to use GROUP BY after the Having clause Mysql
  • PGSQL- syntax error at or near “-“
  • Huge database logging of event type rows and ways to optimize it
  • Why is the following query so bad performance-wise
  • Normalize SQL to the same format
  • MySQL: Replication and local variables

Categories

  • Database Backup
  • Database Design
  • Database Index
  • Database Optimization
  • InnoDB
  • Join
  • MariaDB
  • MongoDB
  • MySQL
  • Oracle
  • Performance
  • Permissions
  • Postgresql
  • Query Performance
  • Replication
  • Security
  • SQL Server
Proudly powered by WordPress / Support by: DizzyCoding