Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003
    Posts
    2

    Lightbulb Unanswered: SQL optimization

    Did somebody know how to optimize this line?!

    SELECT login FROM log WHERE substring (timeDate, 1, 10) = '2003-09-03'

    (timeDate format is 1900-01-01 00:00:00)

    thank you!!

  2. #2
    Join Date
    Jul 2003
    Location
    Amsterdam, Nederland
    Posts
    450

    Lightbulb hmmmm date as string ?????

    SELECT login FROM log WHERE Format(timeDate, "yyyy-mm-dd") = #2003-09-03#

Posting Permissions

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