how to get english month name in 4gl
Posted in 2009
Topics: Stored Procedures & SPL, Connectivity: ESQL/C, 4GL & Embedded SQL, Internationalization & Character Sets
I like to display date like 'Apr.07,2009'.
Owing to the foreign language locale setup.
It display language specific month like "xxx.07,200"
'xxx' is foregin language's April name.
list is my table schema & 4gl perform program:
create table t1 (f1 date);
database test
{
f1 [f000 ]
}
end
tables
t1
attributes
f000 = t1.f1,format="mmm,dd,yy";
end
What should I do to display 'Apr.07,2009'?
joeclhua@gmail.com wrote:
> I like to display date like 'Apr.07,2009'.
> Owing to the foreign language locale setup.
> It display language specific month like "xxx.07,200"
> 'xxx' is foregin language's April name.
>
> list is my table schema & 4gl perform program:
> create table t1 (f1 date);>
> database test
> {
> f1 [f000 ]
> }
> end
> tables
> t1
> attributes
> f000 = t1.f1,format="mmm,dd,yy";
> end
>
> What should I do to display 'Apr.07,2009'?
Er, set the locale appropriately.
--
RGB