SQL date problem

Results 1 to 2 of 2

Thread: SQL date problem

  1. #1
    Join Date
    Dec 1969

    Default SQL date problem

    If the database shows 12/8/01 as the date, how do I use a select satement *IN 6.5* which will allow me to pull only the day (ie. 8) <BR><BR>In 7.0 the command is day(edate), Someone told me the convert function should work but Im not sure how, any ideas?<BR><BR>

  2. #2
    Join Date
    Dec 1969
    Los Angeles, CA

    Default Use the DAY function <eop>


Posting Permissions

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