yep dates and date formatting to me are the trickiest things to deal with in Oracle.
> -----Original Message----- > From: Vorce, Tim (T.) [mailto:tvorce@;ford.com] > Sent: Thursday, November 14, 2002 12:13 PM > To: 'Jacqui Caren'; Kipp, James; Ronald J Kimball > Cc: [EMAIL PROTECTED] > Subject: RE: Trying to get LIKE to work > > > As a follow-up, I noticed that setting the nls_lang > environmental variable causes the dates to be displayed > differently. Doesn't make any sense to me. > > You can force the date format with something like this > select > COUNTRY_ISO3_C,ACCT_NAME_N,LANG_ISO_C,to_char(ACCT_UPDATE_S,'D > D-MON-YYYY:HH:MI:SS'), .... > > Tim Vorce > Ford Motor Company > [EMAIL PROTECTED] > > >
