Re: Help! Looking for Data load utilities
Posted in 1997
This is a multi-part message in MIME format. --------------500A446A880 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Oops forgot to include the date format examples, attached: --------------500A446A880 Content-Type: text/plain; charset=us-ascii; name="dateformats" Content-Transfer-Encoding: 7bit Content-Disposition: inline; filename="dateformats" Following is a summary of the supported date/time formats, if others are required contact me (Art Kagel: kagel@bloomberg.com): Absolute date specifications dates may contain several non-conflicting parts: Time: HH:MM:SS.ff m Hour, minutes, seconds, fraction, & meridian: 12:15, 23:59:59.999, 11:24am. Only hour is mandatory in 12 or 24 hour format. Fractional seconds supports microsecond precision (6-digits or 1/1000000 secs). DST Indicates daylight savings time. If not present depends on date if given or current DST status if not. Date: mm/dd/yy Month, day, 2-digit year. 1900 + yy is assumed. Dates between 1901 and 2037 can be converted. Note separator (/). mm/dd/yyyy Month, day, 4-digit yead. See above. yyyy-mm-dd 4-digit year, month, day. This is ISO 8601 compliant international date format. Note separator (-). mm dd yy mm dd yyyy Month, day, 4-digit year. See above. Note space is separator. dd-MON-yyyy Day, month name (or abbrev), 4-digit year. This is traditional European format. Note Separator. MON dd Month name and day. MON dd, yyyy Month name, day, 4-digit year. This is traditional US date format. dd MON Day and month name. dd MON yyyy Day, month name, 4-digit year. Formal European format. MON DAY yyyy Month name, ordinal day of month (word), 4-digit year. Ex: January fifth, 1995 Note day names may be included. Relative date specifications: nn seconds ago nn minutes before nn hours since nn days after nn weeks ago nn months since nn years before These specify a time in the past relative to current date/time or relative to an explicit date/time. (ex: 5 minutes after 12:00 5/15/95, 3 days before yesterday) yesterday today tomorrow now this second this minute this hour this day this week this month this year These specify a time relative to current time. next second next minute next hour next day next week next month next year These specify a time relative to current time. last second last minute last hour last day last week last month last year These specify a time relative to current time. --------------500A446A880--