4 Replies Latest reply: Feb 8, 2013 8:59 PM by Alessandro Furtado RSS

    Time format

      hi all,

       

      In my application having an filed CDT with datetime format.

       

      Now i needs to have new field only with hours and minutes.

       

      Ex: My CDT with DateTime format will look like below

      CDT

      01/01/2013 00:00:15

      01/01/2013 00:01:00

      01/01/2013 00:50:00

      01/01/2013 01:01:00

      01/01/2013 13:05:00

      01/01/2013 23:50:00

       

      Now i want new field only with Hour ans Minutes as below for above example

      NewCDT

      0

      1

      101

      50

      1305

      2350

       

      Please can anyone let me know how to do this.

       

      Thanks in advance.