[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

Re: HELP!!

lily:
i presume you're not on oracle.  if u r, then just convert via the
TO_CHAR function:
example,

sql>select to_char(sysdate,'Day') from dual;


you'll see what i mean.

> ----------
> From:         Van, Lily[SMTP:Lily.Van@TRANSAMERICA.COM]
> Sent:         Friday, April 17, 1998 2:46 PM
> To:   Multiple recipients of list SQR-USERS
> Subject:      HELP!!
>
> Hi all,
> Does any one know of any .sqc routine to convert to Julian date? I
> need
> to convert the following to 'day of week'.
>  For example 17-APR-1998 is a Friday.
> Thanks,
> Lily
>