PostgreSQL + Django + TimeField (Railway UI bug)
aldolammel
TRIALOP

2 years ago

Railway has a minor UI bug where Django model TimeField are generating columns with 'Invalid Date' value only on Railway UI.

models.py:

class EventAttack(models.Model):
    start_time = models.TimeField(blank=False)

Railway UI:

https://i.imgur.com/4ZJ3Tg.png

Django Shell:

$ from event_attack.models import EventAttack
$ q = EventAttack.objects.first()

$ q.start_time
# output: datetime.time(16, 30)

$ print(q.start_time)
# output: 16:30:00

Django settings.py:

USE_TZ = True
# Date and time format settings
DATE_FORMAT = 'Y-m-d'
TIME_FORMAT = 'H:i'
DATETIME_FORMAT = 'Y-m-d H:i'
SHORT_DATE_FORMAT = 'd/m/Y'
SHORT_DATETIME_FORMAT = 'd/m/Y P'
FIRST_DAY_OF_WEEK = 1  # 0 = Sunday
# Input format settings
DATE_INPUT_FORMATS = [
    #'%Y-%m-%d',
    #'%Y/%m/%d',
    '%d-%m-%Y',
    '%d/%m/%Y',
]
TIME_INPUT_FORMATS = [
    #'%H:%M:%S',
    '%H:%M',
]
DATETIME_INPUT_FORMATS = [
    '%Y-%m-%d %H:%M',
    '%Y/%m/%d %H:%M',
]

Django CMS
https://i.imgur.com/9PB4fZb.png
(It's shown correctly)

0 Replies

Loading...