×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
Limited is being kind. They stink. I don't know if you've ever tried
VARCHAR_FORMAT but I've only ever gotten it to work with two format strings:
"YYYY-MM-DD" and "YYYY-MM-DD HH24:MI:SS". Anything else gets me a QRY2293
error.
Are you on the current PTF Level.
I got VARCHAR_FORMAT to run on 6.1 and 7.1 with almost all kinds of formats
(even IYYY = Year for week ISO and IW = Week ISO).
I just run the following SQL-Statement without any problems:
Values(Varchar_Format(Current_Timestamp, 'DD-MM-YY')),
(Varchar_Format(Current_Timestamp, 'YYYYMMDD')),
(VarChar_Format(Current_Timestamp, 'MM-DD-YYYY HH24:MI')),
(VarChar_Format(Current_Timestamp, 'HH24:MI NNNNNN IW Q YY,MM,DD
DDD'));
And this is the result:
05-02-12
20120205
02-05-2012 07:34
07:34 633183 05 1 12,02,05 036
Mit freundlichen Grüßen / Best regards
Birgitta Hauser
"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them
and keeping them!"
midrange.com
