Genero 2.20.06 is not using GL_DATETIME enviroment variable for formatting DATETIME variables:
Environment used:
OS:
Red Hat Enterprise Linux ES release 4 (Nahant Update 8 )
Architecture: x86_64
% uname -a
Linux xxxxxxx 2.6.9-89.ELsmp #1 SMP Mon Apr 20 10:33:05 EDT 2009 x86_64 x86_64 x86_64 GNU/Linux
% arch
x86_64
% rpm -q kernel
kernel-2.6.9-89.EL
% rpm -q glibc
glibc-2.3.4-2.43
glibc-2.3.4-2.43
# shell used: tsch (/bin/tcsh) version 6.13.00
% rpm -q tcsh
tcsh-6.13-10.el4
% echo $version
tcsh 6.13.00 (Astron) 2004-05-19 (x86_64-unknown-linux) options 8b,nls,dl,al,kan,rh,color,dspm,filec
Informix:
Client-SDK 3.50.FC4:
% esql -V
IBM Informix CSDK Version 3.50, IBM Informix-ESQL Version 3.50.FC4
Software Serial Number AAA#B000000
IBM Informix Dynamic Server 11.50.FC4:
% onstat -V
IBM Informix Dynamic Server Version 11.50.FC4 Software Serial Number AAA#B000000
% dbaccess -V
DB-Access Version 11.50.FC4 Software Serial Number AAA#B000000
Four J's Genero BDL:
Genero BDL 2.20.06
% fgl2p -V
fgl2p 2.20.06 build-1369.77
(c) 1989-2009 Four J's Development Tools
OS Locale settings:
% echo $LANG
pt_PT.iso885915@euro
% env | grep LOCALE
DB_LOCALE=pt_pt.8859-15
SERVER_LOCALE=pt_pt.8859-15
CLIENT_LOCALE=pt_pt.8859-15
% echo $GL_DATETIME
%d/%m/%iY %H:%M:%S
% echo $GL_DATE
%d/%m/%iY
1.)
Using dbaccess the display is correct (the GL_DATETIME setting is used)
% cat prog0001.sql
select cast("2009-07-27 09:15:22" as datetime year to second) as my_datetime -- July 27, 2009 (09h15m22s)
from sysmaster:sysdual;
% dbaccess sysmaster prog0001.sql
Database selected.
my_datetime 27/07/2009 09:15:22
1 row(s) retrieved.
Database closed.
# Correct format.
2.)
Using a simple Genero BDL program dbaccess the display is incorrect (the GL_DATETIME setting is NOT used, the default format is used):
% setenv FGLGUI 0 # The problem is the same in GUI mode (FGLGUI=1)
% cat prog0001.4gl
main
define
l_my_datetime datetime year to second
let l_my_datetime = "2009-07-27 09:15:22" -- July 27, 2009 (09h15m22s)
display l_my_datetime
end main
% fgl2p prog0001.4gl
% fgl2p -o prog0001.42r prog0001.42m
% fglrun prog0001.42r
2009-07-27 09:15:22
# Wrong format!
3.)
Using Informix 4GL-RDS 7.30.UC2 in a similar environment, the display is correct (the GL_DATETIME setting is used):
% fglpc -V
IBM INFORMIX-4GL Version 7.32.UC2
Pcode Version 732
Software Serial Number RDS#N000000
% fglpc prog0001.4gl
% fglgo prog0001.4go
27/07/2009 09:15:22
# Correct format.
Vitorino Ribeiro
SINFIC - Sistemas de Informação Industriais e Consultoria, S.A.
http://www.sinfic.ptvribeiro@sinfic.pt
Sign in for full access
Help
