Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Posts
    205

    Unanswered: Plz give the Meaning of this query - Urgent Plz

    Hi,

    I have a doubt in the following query :

    select ... from ... where some_date

    between to_date('','MM/DD/YYYY') and
    to_date('05/03/2004','MM/DD/YYYY')

    This select query has to_date with empty date as arg. Will this work , then what this the meaning of this query ?

  2. #2
    Join Date
    Mar 2004
    Location
    Berkshire, UK
    Posts
    186
    you will get no rows returned if you have an empty argument

Posting Permissions

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