B4X FEED String toSQL DateTime format

[practicalsoft]

Hi, is there any way to convert a date and time strings to a format acceptable to an SQL database holding it in DateTime type / format, i.e. I have two input fields Date and Time which the user can fill in, i.e. Date: 2020-07-27 and Time: 18:33 but I wish to save them to a MySql database which holds the date and time in that field format (datetime type not varchar() type)
usually the data held in the database would resemble 2020-07-27 18:33:00

برای دیدن لینک ها باید ثبت نام کنید