Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2004
    Posts
    5

    Unanswered: mysql is not showing any other datetime result

    I am a tad confuse with this problem so any help would be greatly appreciated. When I run a query like this

    SELECT *
    FROM windowevents2 where ComputerName = 'LAB01'

    I will only get result for Feb 10 2004, but if I query for a specific date such as

    SELECT *
    FROM windowevents2 where ComputerName = 'CITY06' and
    Datetime = 'Fri Feb 13 13:10:03 2004'

    I would get result for that date. Is there a reason why when querry just by ComputerName force mysql to returns only data for only Feb 10 2004? Thanks

  2. #2
    Join Date
    Jan 2003
    Location
    Paris, France
    Posts
    320
    What data type do you use on Datetime col ?
    Olivier Miossec
    --
    http://www.lasso-developpeur.net/
    --

  3. #3
    Join Date
    Feb 2004
    Posts
    5
    I am using varchar as the data type for DateTime

Posting Permissions

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