Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Convert Day of week (DY) to actual date

Re: Convert Day of week (DY) to actual date

From: Thomas Niering <thomas.niering_at_arcor.de>
Date: 19 Aug 2004 07:54:00 +0200
Message-ID: <9F9rMLYnXzB@thomas.niering.news.arcor.de> 






Hallo Richard,



Richard Brust  <richard_brust_at_yahoo.com> wrote:


> We have a table (duh!) with columns that users have been entering

> day abbreviations - MON, TUE, WED, etc...




> select to_date(s_day, 'DD')




'DD' means 01-31...



Ciao Thomas
Received on Thu Aug 19 2004 - 00:54:00 CDT












Original text of this message













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