rtc DD-MM-YY to mysql YYYY-MM-DD-HH-MM

[viktor_au]

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

[Steve-Matrix]

Hi Viktor,

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

[chipfryer27]

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

[viktor_au]

Thanks.
I think it is easy to re-format the rtc datetime format into a mysql friendly string.
Would be great if you can insert this function into a component.