Advice on using dates with MySQL

Classic Servoy
1

I’m trying to figure out what format I should use to store dates. I can use Date, Timestamp, DateTime, or Varchar. What works best with the Calendar type in Servoy? I need to be able to perform date related calculations if that matters.

Right now, I am having trouble formatting the appearance of the dates to be visually pleasing, and storing them in a MySQL in a proper format. Is there a way to make the date format “look” one way, but submit to the database another?

Any advice on the proper direction would be appreciated.

2

I’m trying to figure out what format I should use to store dates. I can use Date, Timestamp, DateTime, or Varchar.

If you create a date column from within Servoy it sets a timestamp by default in MySql.

Is there a way to make the date format “look” one way, but submit to the database another?

Go into designer, select your date field , and change the “format” property as desired.