- Vertabelo
-
Pomysły
0
Ukończony
MySQL datetime support
KK Cheung 10 lat temu
•
Ostatnio zmodyfikowane przez Rafał Strzaliński (Senior Engineer) 10 lat temu •
2
In our Mysql application, we need to represent a future unknown date as 9999-12-31 00:00:00 and we use the DateTime datatype. Unfortunately, we find that Vertabelo did not support DateTime but only Timestamp, that cannot go beyond 2038.
So we have to manually, modified the SQL generated in Vertabelo to change Timestamp to DateTime.
This reduce the usability of designing big database with a lot of DateTime fields in Vertabelo.
We like to request the adding of Mysql DateTime support.
So we have to manually, modified the SQL generated in Vertabelo to change Timestamp to DateTime.
This reduce the usability of designing big database with a lot of DateTime fields in Vertabelo.
We like to request the adding of Mysql DateTime support.
Customer support service by UserEcho
'datetime' is supported. Just can put 'datetime' in type field by hand. It will not give you an error. Type selection popup contains only most common used types.