Flowcode Support Board

Hi all
The mysql table requires the datetime format as: YYYY-MM-DD HH:MM:SS
Flowcode RTC component gives me a choice of:
0= DD:MM:YY
1= MM:DD:YY

Looks like I have to read and save the values separately as:
YY, MM, HR, MIN (set Secs as 00)
And reformat it to:
YYYY-MM-DD-HH-MM-00
----------------------
Is it some way to do it faster?
Thanks

Hi Viktor,

We're looking into this and hopefully will make an updated component soon.

Hi Viktor

Until Steve updates the component, could you not have your server convert?

You may be able to use the DATE_FORMAT and TIME_FORMAT mysql commands to change.

Just a thought.

Regards