Results 1 to 2 of 2

Thread: date Convesion

  1. #1
    Join Date
    Jul 2013

    Unanswered: date Convesion

    I have a requirement where i have to input the date as mm-dd-yyyy.
    Now in database i can fetch the date as yyyy-dd-mm.
    What conversion i have to make to fetch it as mm-dd-yyyy.

    For ex i am feching data as
    select * from table a where date = '2011-05-25'
    Now how sud i do the conversion so that i can enter the date for ex as '05-25-2011'
    I have tried as for ex
    select * from table a where to_char(to_date(date,'yyyy-mm-dd'),'mm-dd-yyyy')= '05-25-2011'
    but it is throwing error.
    Please help.

  2. #2
    Join Date
    Apr 2012
    Provided Answers: 17
    You could try: char (date_column_name, usa)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts