Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2015
    Posts
    6

    Question Unanswered: sql today/date problems

    Hi,

    How do I select data through these instruction you get the day's data automatically, ie without having to enter specific day,for change_dtim field (??????):


    SELECT Count(Distinct de_do_no), ior.dc_id, ior.whe_id
    FROM system:informix.ior ior
    WHERE (ior.del_do_no Is Not Null) AND ior.change_dtim ???????????
    GROUP BY ior.dc_id, ior.whe_id


    This statement is to put a dashboard so that each time you enter the file it updates the data for the current day!

    Thks a lot,

    Regards,

    Cachado

  2. #2
    Join Date
    Jul 2015
    Posts
    6
    solved

    > today



    Quote Originally Posted by jcachado View Post
    Hi,

    How do I select data through these instruction you get the day's data automatically, ie without having to enter specific day,for change_dtim field (??????):


    SELECT Count(Distinct de_do_no), ior.dc_id, ior.whe_id
    FROM system:informix.ior ior
    WHERE (ior.del_do_no Is Not Null) AND ior.change_dtim ???????????
    GROUP BY ior.dc_id, ior.whe_id


    This statement is to put a dashboard so that each time you enter the file it updates the data for the current day!

    Thks a lot,

    Regards,

    Cachado

Posting Permissions

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