Results 1 to 3 of 3

Thread: how to find the diffrence berween two dates

  1. #1
    Contributing Member
    Join Date
    Apr 2007
    Answers
    46

    how to find the diffrence berween two dates

    How to find the difference between two dates in informatica.if by usinf date_diff funation,then i am getting systax error while using it.can anybody help me to resolve this prob?

    Following is my requirement:-
    If the difference between (DW_ONLINE_ATTRS_UPDATE_DTTM and SYSDATE) OR the difference between (DW_GENERAL_ATTR_UPDATE_DTTM and SYSDATE) then retuen 'A' else 'B'.

    please tell me the how tyo put query in expression transformation.


  2. #2
    Junior Member
    Join Date
    Aug 2006
    Answers
    2

    Re: how to find the diffrence berween two dates

    The resultant of a DATE_DIFF function is a number. It could be in terms on days, months etc.. In your expression use the resultant value and based on the resultant value +ve or -ve, then return A or B


  3. #3
    Contributing Member
    Join Date
    May 2007
    Answers
    45

    Re: how to find the diffrence berween two dates

    Raviayyappan is right. Adding to that please make sure the date format must be equal, since SYSDATE may take Time stamp that means date with time that makes the diff. ..........thx

    Last edited by N SRIRAM K; 09-07-2007 at 11:12 AM. Reason: To add some more
    Thx
    SRIRAM N
    Hope Everything Good

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
Interact