Hello everybody,

how can I separate the date from the time ?
Name of the variable is created_at.

2014-10-22T19:13:48Z


I tried this code:

gen ddate = daily(substr(created_at, 1, 10), "YMD")
gen double ctime = clock(substr(created_at, 12, 12), "hms")

but I only got an output for date and not for the time.

Thanks.