This discussion is archived
1 Reply Latest reply: Mar 23, 2013 6:35 AM by adfLearner RSS

convert string attrib to date

966801 Newbie
Currently Being Moderated
i have a SQL based view object which has an attribute of type string which stores values which are converted from date type column using this to_char(d.status_date,'yyyymmddhh24')
i need to display this vo attribute of type string in UI as date formate dd-MMM-yyyy hh
how can this be done declaratively in jdev 11 1 1 5
  • 1. Re: convert string attrib to date
    adfLearner Explorer
    Currently Being Moderated
    You can use the standard ADF Faces Converter ( Refer Section 6.3.1 http://docs.oracle.com/cd/E25178_01/web.1111/b31973/af_validate.htm#BABHICGB )

    Example 6-2 af:convertDateTime Multiple Patterns

    <af:inputDate id="mdf5" value="2004/09/06" label="attached converter">
    <af:convertDateTime pattern="yyyy/M/d" secondaryPattern="d/M/yyyy" />
    </af:inputDate>



    Thanks,
    Rajdeep

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points