DateTimeField timestamp is always 00:00:00

Using Django Using the ORM
1

Hi All,
Sorry to bother you but I have issue with datetimefield as below:

I’m using datetimefield with default value “auto_now_add”. But when I check it’s value in postgresql time value is always 00:00:00. So I start to think of I’m missing someting in modal definition.

Model:
start_date=models.DateTimeField(auto_now_add=True, blank=True,null=True )

Value in db:
"2024-05-15 00:00:00+00"

I have also tried to add minutes to datetime.now() but in db it did not get reflected. Time is ignored by default.

I wonder why this is happening. Am I missing something?

2

How are you creating these rows? The auto_now_add only applies when an instance is created. If you set or update this field after creation, the auto_now_add no longer applies.

So you’ll want to look at every place where you’re creating or updating the instances for situations where you’re overriding the defaults.