Default Date and Time Properties

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:

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

FieldDescription

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