Datetime field can't choose from panel about sqladmin

[aminalaee]

Hey, thanks for reporting this.

I think maybe a better approach would be to use a Bootstrap DateTime picker and not depend on the browser supports? What do you think?

If you also would like feel free to make a PR for it.

[ischaojie]

Even here it says it should be supported: caniuse.com/input-datetime

But it's the type="datetime-local" supported, not type="datetime":

[aminalaee]

yeah I think it is deprecated, and as I checked the datetime-local is not fully supported, so we can change this to datetime-local and also add a UI library? But one should be enough.

[ischaojie]

I noticed tabler use litepicker as date form picker, But😑:

tabler/tabler#1136

[aminalaee]

@ischaojie Can we still use litepicker and then switch to the new one when tabler switches?

[ischaojie]

The reason is <input type="datetime"> still has almost no support in modern browsers, So It's better to use datetime-local:

https://developer.mozilla.org/en-US/docs/Web/HTML/Element/input/datetime-local

Can we add DatetimeLocalField or some?

[aminalaee]

BTW, what browser and what version are you using?

[ischaojie]

BTW, what browser and what version are you using?

I using chrome 102.0.5005.61

[aminalaee]

hmm.I'm using chrome 101.x.x and it's working alright. weird though.

[ischaojie]

Weird, the code is like this:

class User(Base):
    __tablename__ = "users"

    id = Column(Integer, primary_key=True)
    name = Column(String)
    age = Column(Integer)
    created_at = Column(DateTime, default=datetime.now())


Base.metadata.create_all(engine)  # Create tables

app = FastAPI()
admin = Admin(app, engine)


class UserAdmin(ModelAdmin, model=User):
    column_list = [User.id, User.name, User.age]


admin.register_model(UserAdmin)

[aminalaee]

Even here it says it should be supported: https://caniuse.com/input-datetime

[ischaojie]

I change the code like this:

    @converts("DateTime")
    def conv_DateTime(
        self, model: type, prop: ColumnProperty, kwargs: Dict[str, Any]
    ) -> UnboundField:
        kwargs.setdefault("format", "%Y-%m-%dT%H:%M:%S")
        return DateTimeLocalField(**kwargs)

It's worked now:

I reading the Mozilla doc, Looks like type=datetime has been removed：

One thing the datetime-local input type doesn't provide is a way to set the time zone and/or locale of the date/time control. This was available in the datetime input type, but this type is now obsolete, having been removed from the spec.

https://developer.mozilla.org/en-US/docs/Web/HTML/Element/input/datetime-local#try_it:~:text=This%20was%20available%20in%20the%20datetime%20input%20type%2C%20but%20this%20type%20is%20now%20obsolete%2C%20having%20been%20removed%20from%20the%20spec

[ischaojie]

@ischaojie Can we still use litepicker and then switch to the new one when tabler switches?

litepicker didn't support choosing time, but new easepick supports it.

see: wakirin/Litepicker#1

Or use another lib. or wait for tabler to support it 😝

[aminalaee]

Added flatpickr to handle Date and DateTimes: #288