Oracle Data Types

Results 1 to 2 of 2

Thread: Oracle Data Types

  1. #1
    Join Date
    Dec 1969

    Default Oracle Data Types

    I am new to Oracle and I&#039;m trying to pass a date value in my sql statement. <BR><BR>WHERE NC_DATE_CREAT_WKEND=&#039;"&sDate&"&#039;<BR><BR>I &#039;m getting an "not a valid month" error. Can someone please tell me how I can pass the date to the db.<BR><BR>Thanks!

  2. #2
    Join Date
    Dec 1969

    Default You are missing the ending " (double quotes)


Posting Permissions

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