none
Oracle select query with time format change RRS feed

  • Question

  • Hi,

    Please help me to find select date from below mentioned table in 'DD/MM/YYYY' format.

    Note: In table some rows are null. That should be null in the select query.

    Table1: actual

     Date
     
     
    20080111
    20091127

    Table2: Expected result is

    Date

    11/01/2008

    27/11/2009

    Thursday, August 18, 2016 5:39 AM

Answers

All replies