Table of Contents

Search

  1. Preface
  2. Part 1: Version 10.5
  3. Part 2: Versions 10.4.1 - 10.4.1.3
  4. Part 3: Versions 10.4 - 10.4.0.2
  5. Part 4: Versions 10.2.2 - 10.2.2 HotFix 1
  6. Part 5: Version 10.2.1
  7. Part 6: Version 10.2 - 10.2 HotFix 2

Date and Time Functions

Date and Time Functions

Effective in version 10.2.2, you can apply the following date and time functions to columns in a worksheet when you prepare data:
  • ADD_TO_DATE
  • CURRENT_DATETIME
  • DATETIME
  • DATE_DIFF
  • DATE_TO_UNIXTIME
  • EXTRACT_MONTH_NAME
  • UNIXTIME_TO_DATE
  • Convert Date to Text
  • Convert Text to Date
For more information, see the "Prepare Data" chapter in the
Informatica 10.2.2 Enterprise Data Lake User Guide
.