Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2007
    Posts
    6

    Arrow Unanswered: displaying yesterday's date in DB2

    Hi,
    I am writing a sql ovrride in informatica tool.
    I need to write a query which extracts the data of today and yesterday's data from a table.

    select today,today-1 from tfct_cllg_inmcg;

    in clear terms actually I require a particular day data and previous day data
    like the following query.

    select date,date-1 from tfct_cllg_incmg.

    Could you please help me in getting the sql query.

    you could send me the query to mandla.srinivas@gmail.com
    Last edited by mandla.srinivas; 01-05-07 at 10:46. Reason: added mail id

  2. #2
    Join Date
    Jul 2006
    Location
    Pune , India
    Posts
    433
    values current date

    1
    ----------
    01/05/2007

    values current date - 1 day

    1
    ----------
    01/04/2007

Posting Permissions

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