Re: Client and Server SQL statements work differently??

Hi Henrik,

        It's like:

  1 select l_name, f_name, account_id
  2 from customer
  3* where start_date < to_date('June 1, 1998','Month dd, YYYY')

regards

Jerry

Henrik Staun Poulsen wrote:
>
> Alan,
>
> <I recomment always using the TO_DATE function and never assuming a date
> format will be the default one for a particular database instance.>
>
> PMJI, but what do you mean by this?
> Is it something like
> where sampledate <= To_date('31-12-98')
>
> TIA
> Henrik Staun Poulsen

--

Jerry Gitomer         	ICT Group
jgitomer_at_ictgroup.com	Langhorne PA
jgitomer_at_yahoo.com 	Opinions are mine not those of ICT Group