Oracle FAQ

Your Portal to the Oracle Knowledge Grid

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US

Home -> Community -> Usenet -> c.d.o.tools -> Re: I need an oracle function that converts a date field to the day of the week

Re: I need an oracle function that converts a date field to the day of the week

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Mon, 25 Jun 2001 21:54:32 +0200
Message-ID: <tjf5jlkc52ut24@beta-news.demon.nl>

"Nicolas H. Gutierrez Larraguibel" <ngutierr_at_anakena.dcc.uchile.cl> wrote in message news:Pine.GSO.4.10.10106251526260.23851-100000_at_anakena...
> i.e.
>
> abc_function(2001-06-25)='monday'
>
> Thanks ...
>
> Nicolas Gutierrez L.
> Estudiante de Ingenieria Industrial
> U. de Chile
> ___________________________________
>

Just study the various options of to_char (in this case 'DAY') in your Sql reference manual.

Hth,

Sybrand Bakker, Oracle DBA Received on Mon Jun 25 2001 - 14:54:32 CDT

This message: [ Message body ]
Next message: Elir: "How to Avoid count(*) on web base applictions"
Previous message: Nicolas H. Gutierrez Larraguibel: "I need an oracle function that converts a date field to the day of the week"
In reply to: Nicolas H. Gutierrez Larraguibel: "I need an oracle function that converts a date field to the day of the week"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US