[no subject]

[Krishnan Sarangarajan <ksaranga@RUAN.COM>]

> Enter Pay End Date (e.g. 15-Nov-89):
> (SQR 2514)    Enter a date in one of the following formats:
>         MM/DD/YYYY [HH:MI[:SS[.NNNNNN]] [AM | PM]]
>         MM-DD-YYYY [HH:MI[:SS[.NNNNNN]] [AM | PM]]
>         MM.DD.YYYY [HH:MI[:SS[.NNNNNN]] [AM | PM]]
>         SYYYYMMDD[HH24[MI[SS[NNNNNN]]]]
>
> I changed the date setting in Contro Panel, but I still have the same
> error. Any ideas???
>
> Thanks in advance.
>
> BS
>
Dear Mr. Sadikh,
        With regards to the date format, setting the date format using the
control panel may in fact only alter the date format, the way Windows or the
work-station looks at it. If you would like to alter the manner in which the
database displays the date, or extracts it, you could do the following :

begin-sql
alter session set nls_date_format = 'DD-MON-YYYY'
end-sql
   commit

The above code can reside within your SQR or be called using an include file
but in any case, it will alter the date format only for the session but
hopefully, it helps.

Sincerely,
Krishnan


Krishnan Sarangarajan
ksaranga@ruan.com
  Ruan Transportation
                3200 Ruan Center (DSM 6th Floor)
 Des Moines, IA  50309
[O] (515) 245-5655
[F] (515) 247-2284