Re: help with Date format

[Aboukr Sadikh <bsadikh@YAHOO.COM>]

Hi there,

I found the problem.
In SQR version 4, the way to input dates is:
type=date format=(the format you want), instead of type=date.

Thanks for your hints.

BS.

--- Krishnan Sarangarajan <ksaranga@RUAN.COM> wrote:
> > 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
>

_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com