Simple SQL question

Results 1 to 2 of 2

Thread: Simple SQL question

  1. #1
    Carlos Rivera Guest

    Default Simple SQL question

    I am trying to pull some values out of a database and display them based on certain perameters. For some reason, this statement is not working. Can someone tell me why?<BR><BR>mySQL="SELECT * from tblUsers WHERE " & Hour(Now) - 2 + .5 + "&#039;TimeZoneFactor&#039;" & " = 16.5"<BR><BR>P.S. TimeZoneFactor is just a number that offsets an individual users time zone form the servers time zone.

  2. #2
    Join Date
    Dec 1969

    Default RE: Simple SQL question

    try using timediff

Posting Permissions

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