'Running python script inside Docker container wrong timezone

I'm running a script inside a Docker container (python:3.6) and it shows me the wrong time in the logs. When using the following python code in the python console(inside the container) it gives me the correct timezone.

import datetime
datetime.datetime.now()
datetime.datetime(2019, 8, 3, 17, 26, 25, 662809)

Also, when running the date command inside the container, it gives the correct timezone.

However, I have this print statement in my script:

print("Updating....", datetime.datetime.now())

This however, gives me the wrong timezone (2 hours off).

enter image description here

This is my docker-compose.yml:

version: '3'
services:
  app:
    container_name: app
    build: .
    restart: unless-stopped
    environment:
      TZ: Europe/Amsterdam
    depends_on:
      - db
  db:
    container_name: db
    image: mariadb
    restart: unless-stopped
    environment:
      MYSQL_ROOT_PASSWORD: x
      MYSQL_DATABASE: x
      MYSQL_USER: x
      MYSQL_PASSWORD: x
      TZ: Europe/Amsterdam
    volumes:
      - /volumes/x/db:/var/lib/mysql

This is my crontab file (runs inside the app container)

CRON_TZ=Europe/Amsterdam

*/5 * * * * cd /usr/src/app && /usr/local/bin/python3.6 -u -m x > /proc/1/fd/1 2>/proc/1/fd/2
0,30 * * * * cd /usr/src/app && /usr/local/bin/python3.6 -u -m x > /proc/1/fd/1 2>/proc/1/fd/2
5 0 * * * cd /usr/src/app && /usr/local/bin/python3.6 -u -m x > /proc/1/fd/1 2>/proc/1/fd/2

I tried setting the timezone in docker-compose.yml, that worked for date command and the python console. I tried setting the timezone inside the crontab file, but it still doesn't show the correct timezone in the script.

How do I set the timezone for Python inside a crontab, so that the logs do have the correct timezone? Also, I need to run a script at 00:05 not 22:05, does that work now?



Solution 1:[1]

I got burned by this same problem a while back. Unfortunately, I don't remember the exact fix that ended up working. But here are some pointers:

1) The problem is with Docker, not Python or datetime or anything else. Docker containers struggle to know what the time is. What you want to search for is ways to sync up time inside a container with host.

2) There are many suggested ways of handling time in containers, but I remember them all being work-arounds of sorts. Last I checked there was no clear solution.

3) I would HIGHLY recommend that you do not put cron jobs inside containers. If you need things to run at a certain time, put the crons ON THE HOST, and have them spin up the containers when needed. This is much more reliable.

Solution 2:[2]

If you are trying to sync the timezone in the container with the host machine, you can map the timezone setting from the host. I've done this successfully with the following volume:

-v /etc/localtime:/etc/localtime

Or in your docker-compose.yml file:

volumes:
    - /etc/localtime:/etc/localtime

Solution 3:[3]

you can try to use time.tzset() in the beginning of your code or you can use :

import detetime
import pytz

datetime.now(tz=pytz.timezone('Europe/Amsterdam'))

# or datetime.now(tz=pytz.timezone(os.environ.get('TZ'))

also, check this

Solution 4:[4]

For most users, setting the environment variable as below for your Python container in your docker-compose.yml should be sufficient and effective:

   environment:
      TZ: America/New_York

This was tested with CPython 3.8. Remember to recreate and not merely restart your container after setting it.


Credit: comment by Harsh Nagarkar.

Solution 5:[5]

What is extremely strange, is that I have a python script writing the time to a log (among other things).

import time 
print(time.strftime("%c"))

will return 'Tue Mar 15 14:25:31 2022' for example. If I connect to the container and start python3 and do the commands manually, it returns 'Tue Mar 15 15:25:31 2022'

the container has the timezone set as TZ parameter and if I run 'date' from the shell in the container, the time is indeed the intended localtime. If I omit the TZ, it's reverts to UTC time.

I was forced to pass the TZ as a parameter to the python script and process it.

import time
import os
os.environ['TZ'] = a
time.tzset()
print(time.strftime("%c"))

where 'a' is that passed parameter

It's quite clear in my github project: https://github.com/TrueOsiris/docker-godaddypy as this only has a Dockerfile, one bash script and one python script.

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 Neil
Solution 2 Nick Rundle
Solution 3 kederrac
Solution 4
Solution 5