Parsing date and time into separate fields

[SDCI]

Hello.

I need break apart Activity Date/Time into discrete dates and times.  

For example I need the following activity date/time:  2016-10-24 06:00:24 broken out into 2 separate fields.

Date: 2016-10-24

Time: 06:00:24

[michael_treadwell]

Couple of different options here. I would say the easiest, if you format your DateTime field as a string would be to simply use Text To Columns and split on ' '. The other option, if you are less sure of the incoming format, would be to use the RegEx tool. See attached.

[Joe_Mako · Accepted solution]

Another option is to use a Formula tool, setting the data type for two new fields to Date and Time respectively, both with the same expression.

For example: