Results 1 to 6 of 6
  1. #1
    Join Date
    Mar 2004
    Location
    Wisconsin
    Posts
    4

    Unanswered: Converting date to uppercase

    How do I convert a column of data in a table to all upper case? I've found the UPPER command, but my text only shows how to use that on a select statement.

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1

    Re: Converting date to uppercase

    update mytable set col1 = upper(col1);

  3. #3
    Join Date
    Mar 2004
    Location
    Berkshire, UK
    Posts
    186
    though if the column is a DATE then when you select from it you'll need to specify a format mask to uppercase it

    eg to_date(col1,'DAY MONTH YY')

  4. #4
    Join Date
    Jan 2004
    Location
    Singapore
    Posts
    89
    this topic is quite interesting, i had also posted a thread similar to this. what difference it make by updating date column to uppercase, i have heard that oracle stores date data in number format. Robert's statement is making some sense as the formatting is required at the time of quering. Also another question arise, what is the default format of date when it is retrieved from the table.
    Thanks and Regards,

    Praveen Pulikunnu

  5. #5
    Join Date
    Mar 2004
    Location
    Berkshire, UK
    Posts
    186
    I *think* the default is dd-mon-yyyy

    and I *think* you can change the default by setting something like nls_date_format

  6. #6
    Join Date
    Jan 2004
    Location
    Singapore
    Posts
    89
    thanx robert,

    let me try it out.
    but any idea how the date is actually stored in a date datatype?
    Thanks and Regards,

    Praveen Pulikunnu

Posting Permissions

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