How I add millisecond in naive_datetime or utn_datetime type

[thachtan]

I have some problem with save time with millisecond. How I save it in Oracle with jamdb_oracle

[vstavskyi]

example

Ecto.Adapters.SQL.query(YourApp.Repo, "update tabl set tim=:1", [{{2022,2,24}, {4,0,0,123000}}])

[vstavskyi]

Recommend using functions like TO_DATE etc.

[thachtan]

Thank you for this example with query.

But I want to set millisecond with type :naive_datetime_usec or :utc_datetime_usec in change set and timestamps.

[vstavskyi]

try now commit

[thachtan]

It works!!! Thanks you for take time to help this issue ^^