7 Replies Latest reply: Feb 29, 2016 5:33 AM by satya_ys satya_ys RSS

    Timestamp

    satya_ys satya_ys

      Hi,

      how to convert time stamp into date format(e.g.: 2/22/2016  12:00:00 AM) this is the date and time i want date as separate and time as separate ... can you  please  check it i was give like that but i didn't get the result

         date(date#( OrderDate, 'dd/mm/yyyy hh:mm:ss'),'DD-MMM-YYYY')  as Date,

        time(Time#( OrderDate, 'dd/mm/yyyy hh:mm:ss'),'hh:mm') as time

       

       

      regards.

      Sai Madhu

      reddys310

      gwassenaar

      ogster1974

      mtonaveen06