seperating time and date from time stamp
Hai,
Can somebody tell me how time and date are seperated from a time stamp with format like 12/01/2006 1:21:36
I want 12/01/2006 in one object and 1:21:36 in another object.
Also as BW takes only format YYYYMMDD, does having 12/01/2006 make any difference? If yes then how can I convert this?
Thank you.