SQL query question (comparing against current date)

Discussion in 'OT Technology' started by PPI Typhoon, Mar 9, 2006.

  1. PPI Typhoon

    PPI Typhoon Guest

    I'm trying to get something where orders placed have a ship date before today, meaning they are behind schedule on shipping.

    Select Order_no, customer_name
    from orderheader_sql
    where shipping_date < current date

    What is it for returning today's date??

    Thanks in advance.
  2. PPI Typhoon

    PPI Typhoon Guest

    nevermind, found it finally.

    It's getdate()

Share This Page