Db and dates

Results 1 to 2 of 2

Thread: Db and dates

  1. #1
    Join Date
    Dec 1969

    Default Db and dates

    i am trying to write an SQL statement that selects all records in a db that have been entered today. When a record is entered into the db the time and date are stored in the TimeOpened field using the now function. How do i write an SQl staement WHERE TimeOpened= todays date? (just reads the date and ignores the time)

  2. #2
    Kasper Guest

    Default RE: Db and dates

    If you&#039;re stuck then use the DateAdd function in combination with the BETWEEN ## AND ## sql clause.<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