7 Replies Latest reply on Nov 17, 2014 12:48 PM by Mohammad Rehman

    Have a requirement to convert date value in database to readable format MM/DD/YYYY

    Nilesh Sawant
      Share This:

      Hi Team,

       

      Need help on below query

       

       

      We have a requirement to convert date value in database to readable format MM/DD/YYYY. A database view of CMDB class BMC_ComputerSystem is created and a date (date only) field need to be converted.

       

      is there a database (Oracle) formula which can be used for conversion.

       

       

      Have successfully converted date/time field using below formula and now need help for date field.

       

       

      (TO_CHAR ((TO_DATE ('01/01/1970 00:00:00','MM/DD/YYYY HH24:MI:SS')+( b.ReceivedDate / 86400)),'MM/DD/YYYY HH24:MI:SS')) as ReceivedDate.

       

      Any idea on the above issue