In the Date/Time page, set up the initial properties assigned to any new fields when you set the field's Data Type property to one of the following types:
Custom Date & Time
Date
Date & Time
You can set default properties for a single message definition in the New Message Definition wizard when you create a new message definition or globally for your entire workspace by selecting Windows|Preferences|Sybase, Inc.|Message Designer|Message Defaults.
At design-time, when you create a message definition, the field inherits the default properties you selected.
Date/Time Properties
Field | Description | |
---|---|---|
Y2k Cutoff | To specify how a 2-digit year from 00-99 is interpreted as a 4-digit year, enter a number from 0 to 99 inclusive. Any 2-digit year >= the Y2k Cutoff becomes 20XX. Any 2-digit year < the Y2k Cutoff becomes 19XX. For example, if you enter 75, all 2-digit input dates from 75 to 99 are designated as 1975 to 1999 output dates. All 2-digit input dates from 00 to 74 are designated as 2000 to 2074 output dates. | |
Date Time Format | Enter your own custom date/time format or select a predefined template that represents the format of any Custom Date & Time fields you add to the message definition. For example, select yy-MM-dd hh:mm:ss to represent date/time fields formatted similar to 95-12-03 23:30:59. As you enter the Java time pattern string, the bottom status line of the main Sybase WorkSpace dialog dynamically displays a formatted example date and time. For a summary of codes you can enter in this field, see Supported Date and Time Format Codes. | |
Show Formatted Date | After you select a Date Time Format, click Show Formatted Date. | |
Use Sample Date | Choose Use Sample Date to display the sample formatted date/time using the same arbitrary values every time. | |
Use Current Date | Choose Use Current Date to use the current date/time value from the OS. |
Send your feedback on this help topic to Sybase Tech Pubs: pubs@sybase.com