Dateandtime search

  • <-- new at sql

    I'm trying to run a query on time but my date and time are in the same field.

    Example I'm trying to get the rows between 6/22/2008 12:00:54 AM to 6/23/2008 12:11:57 AM

    Unfortunantly I don't have the luxury of splitting up the date and time.

    Select * from log where dateandtime ?????????

  • amdavis (6/23/2008)


    <-- new at sql

    I'm trying to run a query on time but my date and time are in the same field.

    Example I'm trying to get the rows between 6/22/2008 12:00:54 AM to 6/23/2008 12:11:57 AM

    Unfortunantly I don't have the luxury of splitting up the date and time.

    Select * from log where dateandtime ?????????

    what is the problem with:

    Select * from log where dateandtimecolumn between '6/22/2008 12:00:54 AM' and '6/23/2008 12:11:57 AM'


    * Noel

  • Thanks! I need to learn more keywords 😀

    http://www.1keydata.com/sql/sql-syntax.html

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply