Informatica ETL : Convert Any date to end of day i.e. 23:59:59 or 11:59:59



SET_DATE_PART(
        SET_DATE_PART(
           SET_DATE_PART(v_Your_date_Port, 'HH', 23)
                                      , 'MI', 59)
                            , 'SS', 59)



By -

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Limitations of Pushdown Optimization - PDO

Limitations of Pushdown optimization. Source and Target and Lookups must be in same database server for full Pushdown. Expressions w...