It looks like your SQL*Plus session has a ALTER SESSION SET NLS_DATE_FORMAT = 'DD/MM/YY HH:MI:SS AP'; somewhere. (I'm not sure about the AP). Personally, I prefer 'YYYY-MM-DD HH24:MI:SS' because it's easier for external programs to deal with.
You could do the same in your DBI session, but TO_CHAR() allows better control. -- Mac :}) ** I normally forward private questions to the appropriate mail list. ** Give a hobbit a fish and he eats fish for a day. Give a hobbit a ring and he eats fish for an age. ----- Original Message ----- From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, October 22, 2001 18:06 Subject: problem with select select IDEN,HORA_SUBG_HORA from sm_subgrupos_horas_dat; this is the result of de query from the data base (oracle) IDEN HORA_SUBG_HORA 131 7/10/01 11:08:00 AM 136 1/01/01 1:00:00 AM But ,if I do it on DBI,DBD with the same query this is showed: IDEN HORA_SUBG_HORA 131 7-OCT-01 136 1-JAN-01 I don�t want 7-OCT-01 .... i need 7/10/01 11:08:00 AM
