silvaac

Split daate/time

Discussion created by silvaac on Mar 18, 2014
Latest reply on Mar 19, 2014 by Wayne_Whitley
Hi, I am sure this is very easy but I not very good at SQL/Phyton script
I have a field with date/time and need to split into 2 field one for date and another one for time

Example:
Date/Time  into column Date and columnTime
23/02/2013 11:49:00 AM Split into Date 23/02/2013 in another column time 11:49:00 AM
27/02/2013 8:07:00 AM   split into Date 27/02/2013 in another column time  8:07:00 AM
27/02/2013 8:51:00 AM   split into  Date 27/02/2013 in another column time 8:51:00 AM

and so on I have over 33000 so I can really do it by hand
thanks a lot
sil

Outcomes