[INUG-Users] About the proposed change in POSIX format in Netcool/OMNIbus date/time function

[Zhenni Yan]

Hi, 

There might be some changes to below Netcool/OMNIbus functions. Please 
could you help to assess the impact on you: 

date/time formatting functions:
ObjectServer SQL functions: to_char  rules file functions: timetodate
 date/time parsing functions:
ObjectServer SQL functions:to_date and rules file functions datetotime

1) Slight difference in the output of POSIX format %c, %x, %X, %r. the 
result returned by time formatting function stands for the same time point 
as before unambiguously but it?s represented in a different format.
for example:  for %c format
Current output: Mon Jan 12 15:10:35 2009
New output: Monday, January 12, 2009 3:10:35 PM United Kingdom Time
2) Some POSIX formats with range starting from 0 might NOT be supported 
for both formatting and parsing.
%U: is replaced by the week number of the year (Sunday as the first day of 
the week) as a decimal number [00,53].
%W:is replaced by the week number of the year (Monday as the first day of 
the week) as a decimal number [00,53]. All days in a new year preceding 
the first Monday are considered to be in week 0.
%w: is replaced by the weekday as a decimal number [0,6], with 0 
representing Sunday.
3) Slight difference in the output of following POSIX formats for most of 
the locales other than C, POSIX, en_GB, en_US.
%A, %a, %B, %b, %p
for example: for French locale
Current output: mer. déc. 17 12:24:21 2008 GMT
New output: mer déc  17 12:24:21 2008 GMT
Note there is a dot after day and month name.
4) For some locales: Hindi, Arabic the formatted date/time string will be 
digit in Hindi digit instead of Western Arabic digit. 
5) For Thai locale the result uses different Thai calendar instead of 
Gregorian calendar which shows year 2008 as year 2551.

Thanks,
Zhenni





Unless stated otherwise above:
IBM United Kingdom Limited - Registered in England and Wales with number 
741598. 
Registered office: PO Box 41, North Harbour, Portsmouth, Hampshire PO6 3AU