Extracting date and hour component from time stamp in diadem ?

[saurabhpr]

Hi all, 
I am just getting started with DIADEM.
I have a column with time stamp format as 4/12/2014  12:03:00 AM, i need to extract date and hour compenents only and store in another column.
Can anyone please give me some lead on this?
Please ask for extra infor if required

[saurabhpr]

Hi figured it out.
I used this.

str(chd(i,"P1_ACCH_1/Time_Stamp"),"#MM/DD/YYYY hh"))