Communities
A collaborative platform to connect and grow with like-minded Informaticans across the globe
Product Communities
Connect and collaborate with Informatica experts and champions
Discussions
Have a question? Start a Discussion and get immediate answers you are looking for
User Groups
Customer-organized groups that meet online and in-person. Join today to network, share ideas, and get tips on how to get the most out of Informatica
Get Started
Community Guidelines
Knowledge Center
Troubleshooting documents, product guides, how to videos, best practices, and more
Knowledge Base
One-stop self-service portal for solutions, FAQs, Whitepapers, How Tos, Videos, and more
Support TV
Video channel for step-by-step instructions to use our products, best practices, troubleshooting tips, and much more
Documentation
Information library of the latest product documents
Velocity (Best Practices)
Best practices and use cases from the Implementation team
Learn
Rich resources to help you leverage full capabilities of our products
Trainings
Role-based training programs for the best ROI
Certifications
Get certified on Informatica products. Free, Foundation, or Professional
Product Learning Paths
Free and unlimited modules based on your expertise level and journey
Resources
Library of content to help you leverage the best of Informatica products
Tech Tuesdays Webinars
Most popular webinars on product architecture, best practices, and more
Product Availability Matrix
Product Availability Matrix statements of Informatica products
SupportFlash
Monthly support newsletter
Support Documents
Informatica Support Guide and Statements, Quick Start Guides, and Cloud Product Description Schedule
Product Lifecycle
End of Life statements of Informatica products
Ideas
Events
Change Request Tracking
Marketplace
English
  • Data Archive 6.5
  • All Products

Table of Contents

Search

  1. Preface
  2. Starting Data Archive
  3. System Configuration
  4. Database Users and Privileges
  5. Source Connections
  6. Target Connections
  7. Archive Store Configuration
  8. Datatype Mapping
  9. Database Optimization
  10. SAP Application Retirement
  11. z/OS Source Data Retirement
  12. Seamless Data Access
  13. Data Discovery Portal
  14. Security
  15. SSL Communication with Data Vault
  16. LDAP User Authentication
  17. Auditing
  18. Running Jobs from External Applications
  19. Salesforce Archiving Administrator Tasks
  20. Upgrading Oracle History Data
  21. Upgrading PeopleSoft History Data
  22. Data Archive Maintenance
  23. Appendix A: Datetime and Numeric Formatting
  24. Appendix B: Data Archive Connectivity

Administrator Guide

Administrator Guide

Back Next

Datetime Format Strings

Datetime Format Strings

Enter datetime formats through a format string that contains one or more alphabetic characters. The number of characters in the string determines how Data Archive interprets the datetime value.
The following table describes the datetime format characters that Data Archive uses:
Character
Description
a
Time period for a 12-hour clock as text. For example, "PM."
d
Day in month as a number. Range is 1 through 31.
D
Day in year as a number. Range is 1 through 366.
E
Day of the week as text. For example, "Tuesday" or "Tue."
f
Fractional seconds as a number. Display fractional seconds as they are stored in the database.
F
Day of the week in the month as a number. Range is 1 through 5. For example, "3" for the third Tuesday of the month.
G
Era as text. For example, "AD" or "BC."
h
Hour in day for a 12-hour clock as a number. Range is 1 through 12.
H
Hour in day for a 24-hour clock as a number. Range is 0 through 23.
k
Hour in day for a 24-hour clock as a number. Range is 1 through 24.
K
Hour in day for a 12-hour clock as a number. Range is 0 through 11.
m
Minute in hour as a number. Range is 0 through 59.
M
Month in year as a number or text.
If you enter one or two characters, Data Archive interprets the month as a number. Range is 1 through 12. For example, "7" or "07."
If you enter three or more characters, Data Archive interprets the month as text. Range is January through December. For example, "Jul" or "July."
s
Second in minute as a number. Range is 0 through 59.
S
Fractional seconds as a number. Display trailing zeros. Range is 0 through 999,999. For example, "SSS" for milliseconds.
w
Week in year as a number. Range is 1 through 52.
W
Week in month as a number. Range is 1 through 5.
y
Year. For example, "1995" or "95."
z
General time zone. For example, "Pacific Standard Time," "PST," or "GMT-08:00."
For time zones represented by a GMT offset value, the range for hours is 0 - 23, and the range for minutes is 00 through 59.
Z
RFC 822 time zone. For example, "-0800."
The range for hours is 00 - 23, and the range for minutes is 00 through 59.
The following table describes how Data Archive interprets the number of characters in display formats and search formats for text, numeric, year, and time zone values:
Datetime Value Type
Display Formats
Search Formats
Text values
To display the abbreviated form of a datetime value, enter three or fewer characters. To display the full form of a datetime value, enter four or more characters.
Data Archive accepts both the abbreviated form and the full form of datetime values, no matter how many characters that you enter.
Numeric values
The number of characters that you enter determines the number of digits that Data Archive displays. If you enter extra digits, Data Archive pads the result with leading zeros. For example, if the display format is
DDD
 and the day of the year is January 1, Data Archive displays the day as 001.
Data Archive ignores the number of characters.
Year
To display a two-digit year, enter two characters. To display a four-digit year, enter four characters.
Data Archive interprets two characters as a two-digit year. To determine the century, Data Archive adjusts the date to be within 80 years before and 20 years after the current year. For example, it is 2011, and the search format is
mm/dd/yy
. If you enter 10/31/65, Data Archive interprets the year as 1965. If you enter 10/31/05, Data Archive interprets the year as 2005.
Data Archive interprets one character and three or more characters literally. For example, the search format is
mm/dd/yyyy
. If you enter 12/25/11, Data Archive interprets the date as December 25, 11 AD. If you enter 12/25/-3, Data Archive interprets the date as December 25, 4 BC.
General time zone
Data Archive displays the time zone name. If the time zone does not have a name, Data Archive uses a GMT offset value with the following syntax:
GMT +/- HH:mm
Data Archive accepts the general time zone or the RFC 822 time zone.
RFC 822 time zone
Data Archive uses the following syntax:
+/- HH:mm
Data Archive accepts the general time zone or the RFC 822 time zone.
0 COMMENTS
We’d like to hear from you!