Post reply

Dateandtime search

  • June 23, 2008 at 2:44 pm

    #188405

    <-- 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 ?????????

  • June 23, 2008 at 3:19 pm

    #833040

    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

  • June 24, 2008 at 7:11 am

    #833290

    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