> From: [EMAIL PROTECTED] > To: "Kipp, James" <[EMAIL PROTECTED]> > Cc: "'Vorce, Tim (T.)'" <[EMAIL PROTECTED]>, "'Jacqui Caren'" ><[EMAIL PROTECTED]>, "Ronald J Kimball" <[EMAIL PROTECTED]>, >[EMAIL PROTECTED] > Subject: Re: Trying to get LIKE to work > Date: 15 Nov 2002 13:39:04 +0100
> "Kipp, James" <[EMAIL PROTECTED]> said: > > > yep > > dates and date formatting to me are the trickiest things to deal with in > > Oracle. > > I think that there are 2 levels of settings. The main one is the language > setting, that sets other settings (date, numerics, ...), so that it covers 80% > of what the guy speaking this language wants. Then you can refine the setting > by setting them specifically. > > So chnging language will change date, except if you set date format > specifically. I hope I'm right on that, I'm not 100% sure. > > -- > dams > > or you may handle it in an explict way by using the to_char fucntion in your orace calls. You will be no longer database independent but you will be settings independent. Li
