Entering Date into Oracle

Results 1 to 2 of 2

Thread: Entering Date into Oracle

  1. #1
    Join Date
    Dec 1969

    Default Entering Date into Oracle

    Greetings,<BR>Basically I&#039;m getting an incompatible entry type for entering in date via asp. The code is ," & Request("txtReleaseDate")& "&#039;,<BR>Does anyone know what it should be to take in date format,<BR>Thanks in advance,<BR>Patros

  2. #2
    Join Date
    Dec 1969

    Default RE: Entering Date into Oracle

    You need to use to_date(whateverdate, dateformat) in yor sql statement.<BR><BR>select name from result where DATE_AUTHORISED &#062; TO_DATE(&#039;12-FEB-03&#039;,&#039;DD/MM/YY)&#039;<BR><BR>as an example.<BR>

Posting Permissions

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