DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: pl/sql: select into date is wrong format

Threaded View

  1. 09-19-2007, 04:53 PM #2
    jay_l_a
    jay_l_a is offline Junior Member
    Join Date
    Sep 2007
    Posts
    36
    If it's a DATE, it's a date. It's right, Oracle understands it, don't worry about how it appears to YOU, it's not a varchar. If you are not seeing it right you may want to format it with TO_CHAR, rather than TO_DATE.

    If this is too annoying take a look at NLS_DATE_FORMAT in your init files.

    J
    Last edited by jay_l_a; 09-19-2007 at 04:55 PM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width