Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

how do you deal with timezone issues? [duplicate]

Tags:

timezone

php

sqlite

mysql

postgresql

For a scheduling system, what's the best way to save the timezone of client/event in a central server database coming from multiple sources mobile,web,client app.

  • How do you store the dates? Alarms, reminders etc...
  • How do you handle the DST setting?
  • How do you handle the events if client has traveled to a different location?

I need the solution to work with all databases in tags.

like image 681
Pentium10 Avatar asked Jan 27 '10 15:01

Pentium10

People also ask

How does Java handle time zone issues?

The Right Way: TZDB Timezone ID The right way to handle DST in Java is to instantiate a Timezone with a specific TZDB Timezone ID, eg. “Europe/Rome”. Then, we'll use this in conjunction with time-specific classes like java.

How do you change timezone from one time zone to another in python?

Convert to new timezone using . astimezone() on the newly localized datetime/timestamp from step 2 with the desired timezone's pytz object as input e.g. localized_timestamp. astimezone(new_timezone) .

2 Answers

Everything in UTC, and another column for the offset.

like image 100
Ignacio Vazquez-Abrams Avatar answered Sep 27 '22 21:09

Ignacio Vazquez-Abrams

These are the key points to the strategy I tend to use.

  • Every date is UTC internally to the system.
  • Users are shown dates in the their local timezone.
  • We allow users to override the timezone they are using in case they travel and they want to keep the timezone consistent.
  • Make the timezone easily visible. Either display it with the time or as part of the column header.
like image 43
Steve g Avatar answered Sep 27 '22 22:09

Steve g
Sign in to Comment

Related questions

Does PHP always support passing more arguments than the method expected?
Display image from laravel controller
json_encode adding lots of decimal digits
Generate CSV, download to local machine and save to the server at the same time
AOP in plain PHP that doesn't require any PECL-extentions (Go!) - How?
Laravel - Get records from one table that doesn't exist in another with a where clause attached
How to downgrade php7 to php5.6 in mac high sierra
composer asking oauth token for download public repo
Caching web routes with forced url in laravel
How to use Symfony Messenger component in standalone code to send AMQP messages
SQLite/PHP read-only?
Embedded Web Server in .NET
How evil is $_REQUEST and what are some acceptable Band-Aid countermeasures?
error clause for file_put_contents
/var/www/ folder structure for PHP project
Wrap Text in P tag
mysqli_real_escape_string AND prepared statements?
CakePHP Session variable use in view page?
PHP Curl Paypal Sandbox
store AM PM time string into TIME datatype in MySQL and retrieve with AM PM while display?

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!