Re: Date questions

From: Kees van 't Hoff <keesh_at_cwi.nl>
Date: 1998/01/20
Message-ID: <keesh.885292068@news.cwi.nl>#1/1

"Laura Bellini" <laura.bellini_at_compaq.com]> writes:

>Hi -
>Can someone tell me how to just get the day of the week out of a date in
>Oracle?

>For example, is 1/19/98 a 'monday', 'tuesday', 'wednesday', etc.?

>I know SQL Server has a function that allows you to do this - can't seem to
>find it in Oracle.

>Thanks in advance!

>Laura Bellini
>laura_bellini_at_compaq.com

select to_char(sysdate,'day') from dual;

Regards,
Kees.

-- 
================
Kees van 't Hoff (Kees.van-t.Hoff_at_cwi.nl)
CWI; Amsterdam; The Netherlands.
URL: http://www.cwi.nl/~keesh

Received on Tue Jan 20 1998 - 00:00:00 CST