oracle sql

Results 1 to 2 of 2

Thread: oracle sql

  1. #1
    Join Date
    Dec 1969

    Default oracle sql

    Hi,<BR><BR>I am trying to create a query that will have the following WHERE clause...<BR><BR>WHERE my_date &#062;= first_day_of_the_year<BR><BR>where first_day_of_the_year would be the 1st of Jan for the current system date year.<BR><BR>I am not very familiar with Oracle SQL so your help would be much appreciated.<BR><BR>Cheers<BR><BR>Hugh

  2. #2
    Join Date
    Dec 1969

    Default RE: oracle sql

    WHERE my_date &#062;= TO_DATE(&#039;01/01/2003&#039;,&#039;MM/DD/YYYY&#039;)<BR><BR><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