Home Community Discussion Forums Most Active Software Boards DIAdem Topic

DIAdem

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Extracting date and hour component from time stamp in diadem ?

Extracting date and hour component from time stamp in diadem ?

‎05-27-2014 01:19 AM

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

0 Kudos
Message 1 of 2
(4,987 Views)
Reply

Re: Extracting date and hour component from time stamp in diadem ?

‎05-27-2014 03:25 AM

Hi figured it out.
I used this.

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

0 Kudos
Message 2 of 2
(4,980 Views)
Reply