# Issues with time across different time zone

**URL:** <https://forum.djangoproject.com/t/issues-with-time-across-different-time-zone/41400>\
**Category:** Using Django\
**Created:** [June 12, 2025, 12:53am UTC](https://forum.djangoproject.com/t/issues-with-time-across-different-time-zone/41400 "2025-06-12T00:53:51Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![songlisp123](https://sea2.discourse-cdn.com/flex026/user_avatar/forum.djangoproject.com/songlisp123/32/28802_2.png) [@songlisp123](https://forum.djangoproject.com/u/songlisp123)\
**Post date:** [June 12, 2025, 12:53am UTC](https://forum.djangoproject.com/t/issues-with-time-across-different-time-zone/41400/1 "2025-06-12T00:53:51Z")

</div>

Hi everyone, I’ve encountered a strange issue. Here is my model function:

```auto
# Create your models here.
class Post(models.Model):
    """创建帖子对象"""
    class Status(models.TextChoices):
        PUBLISHED = "PB","published"
        DRAFT = "DF","Draft"
        EDIT = "ED","Edit"
    author = models.ForeignKey(User,on_delete=models.CASCADE)
    #标题
    title = models.CharField(max_length=50)
    #创建对搜索引擎友好的片段
    slug = models.SlugField(max_length=50,unique=True)
    #发布时间
    published = models.DateTimeField(default=timezone.now)
    #更新时间
    updated = models.DateTimeField(auto_now_add=True)
    #帖子状态
    status = models.CharField(
        max_length=2,
        choices=Status,
        default=Status.DRAFT   
    )

    #帖子正文
    body = models.TextField()

    #定义元素具
    class Meta:
        ordering = ["-published"] #以默认创建帖子的时间排序
        #创建优化索引
        indexes = [
            models.Index(fields=['title']),
        ]

    def __str__ (self):
        """返回标题"""
        return self.title
    
    def get_absolute_url(self):
        return reverse(
            "blog:post_detail",
            args=[
                self.published.year,
                self.published.month,
                self.published.day,
                self.slug
            ]
        )

```

Here is the view function for finding a specific post:

```auto
def post_detail(request,year,month,day,post):
    """帖子详情"""
    try:
        print(f"查找参数: year={year}, month={month}, day={day}, slug={post},title={post.title}")
        post = Post._default_manager.get(
            published__year=year,
            published__month=month,
            published__day=day,
            slug=post
            )
        print(f"找到帖子: {post.title}")
    except Post.DoesNotExist:
        raise Http404("未找到帖子")
    return render(
        request,
        "blog/post_detail.html",
        {
            "post":post
        }
    )

```

The issue is in this line: `published = models.DateTimeField(default=timezone.now)` . This is because I modified the timezone setting in the _[settings.py]_ file.

```auto
LANGUAGE_CODE = "zh-hans"

TIME_ZONE = "Asia/ShangHai"

USE_I18N = True

USE_TZ = True

```

**A strange phenomenon occurs when I create posts in the evening:**  
**Below is a post created on June 12, 2025.**

 ![image](https://us1.discourse-cdn.com/flex026/uploads/djangoproject/original/3X/5/8/58fcfb97666d8fa225a22eec08ef028fba680dcc.png)  
However, when I click into it, these warnings appear:

```auto
Page not found (404)
未找到帖子
Request Method:	GET
Request URL:	http://localhost:8001/blog/post/2025/6/11/asdsacasc/detail/
Raised by:	blog.views.post_detail
Using the URLconf defined in my_project_settings.urls, Django tried these URL patterns, in this order:

admin/
blog/ [name='post_list']
blog/ user_posts/<int:id>/posts [name='user_posts']
blog/ post/<int:year>/<int:month>/<int:day>/<slug:post>/detail/ [name='post_detail']
The current path, blog/post/2025/6/11/asdsacasc/detail/, matched the last one.

```

It shows that the post was not found, and the date displayed is June 11, 2025. What’s going on? I tested the post’s published time in the _python manage.py shell_

```auto
>>> post.title
'asdsacasc'
>>> post.published
datetime.datetime(2025, 6, 11, 17, 42, 41, 988920, tzinfo=datetime.timezone.utc)

```

Why is it June 11th?

Why is this happening? I hope everyone can help me! Thank you all!

---

<div class="post-metadata">

**Author:** ![songlisp123](https://sea2.discourse-cdn.com/flex026/user_avatar/forum.djangoproject.com/songlisp123/32/28802_2.png) [@songlisp123](https://forum.djangoproject.com/u/songlisp123)\
**Post date:** [June 12, 2025, 1:20am UTC](https://forum.djangoproject.com/t/issues-with-time-across-different-time-zone/41400/2 "2025-06-12T01:20:53Z")

</div>

My admin site displays the creation time of posts：  
 ![image](https://us1.discourse-cdn.com/flex026/uploads/djangoproject/optimized/3X/b/9/b9143201c3bfd6cb81826a11f5323bcb081d9189_2_690x22.png)

---

<div class="post-metadata">

**Author:** ![antoinehumbert](https://sea2.discourse-cdn.com/flex026/user_avatar/forum.djangoproject.com/antoinehumbert/32/14851_2.png) [@antoinehumbert](https://forum.djangoproject.com/u/antoinehumbert)\
**Post date:** [June 12, 2025, 9:58pm UTC](https://forum.djangoproject.com/t/issues-with-time-across-different-time-zone/41400/3 "2025-06-12T21:58:22Z")

</div>

Hello, Datetimes are stored in database.in the UTC timezone, hence the value returned by

> [@songlisp123](#):
>
> ```auto
> >>> post.published
> datetime.datetime(2025, 6, 11, 17, 42, 41, 988920, tzinfo=datetime.timezone.utc)
> 
> ```

When the date is displayed in the admin, it is converted to current timezone. Also when using datetimes lookups in the databse, the datetimes are converted to the current timezone (see [QuerySet API reference | Django documentation | Django](https://docs.djangoproject.com/en/5.2/ref/models/querysets/#year)).

In your case, the date parts coming from the URL are in the UTC timezone, so it doesn’t match with the date filtering in database which is done in the ShangHai timezone.

To get a correct match, your URL must be generated in the current timezone. To do that, in `get_absolute_url`, you can first convert the published date to current timezone before generating URL from this new datetime:

```auto
local_published_datetime = self.published.astimezone(timezone.get_current_timezone())

```