1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

  2. Anuncie Aqui ! Entre em contato fdantas@4each.com.br
Cookies Anuncie aqui Patrocinador Anuncios

Progress OpenEdge query for last hour

Discussão em 'StackOverflow' iniciado por fdantas, Setembro 14, 2017.

  1. fdantas

    fdantas Administrator Moderador

    I have a query which calls results from the last day, but I would like to only call the last hour. Its from a Progress OpenEdge 11.2 database.

    The current code to call the past day

    (T1.created_date_time BETWEEN TO_CHAR(CURDATE() - 1, 'yyyy-mm-dd') + ' '
    + '00:00:00' AND TO_CHAR(CURDATE(), 'yyyy-mm-dd') + ' ' + '23:59:59')


    I think the query is TO_CHAR(CURTIME(), 'hh:mm:ss' -1) but I couldn't get it right.

    Continue reading...
    fdantas, Setembro 14, 2017
    #1

Compartilhe esta Página