to date

Results 1 to 2 of 2

Thread: to date

  1. #1
    Join Date
    Dec 1969

    Default to date

    if the date default in oracle is dd-mon-yy<BR><BR>do i need to use to_date(datefield, &#039;dd-mon-yy) for oralce to handle the date.<BR><BR>because I get a null value trying to be inserted?

  2. #2
    Join Date
    Dec 1969

    Default Been awhile since I worked on Oracle but

    I&#039;m pretty sure as long as the string is converted to an Oracle date regardless of the format, it should be ok. You are missing a single quote around &#039;dd-mon-yy&#039; though.<BR><BR>The to_date and to_char functions convert values to an from Oracle&#039;s internal date storage format.

Posting Permissions

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