Hi all,
Thanks to those for showing the building blocks of Date Time conversions. Here is an additional expression.
If you need to import a Time and Date into MySQL the following expression will convert the Simio Date Time format to the MySQL format.
String.Substring(DateTime.ToString(TimeNow), 7, 4) + "-" + String.Substring(DateTime.ToString(TimeNow), 4, 2) + "-" + String.Substring(DateTime.ToString(TimeNow), 1, 2) + " " + String.Substring(String.FromDateTime(TimeNow), 12,
{See corrected posting below}
Hope it helps.
Regards,
Hugo