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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Week numbers and days

Re: Week numbers and days

From: Mike Sherrill <MSherrill_at_compuserve.com>
Date: Mon, 17 Feb 2003 14:30:22 -0500
Message-ID: <i2d25vs0dthod7it5nkrt2kt02cbdh7amo@4ax.com> 





On Mon, 10 Feb 2003 09:09:47 -0800, DA Morgan
<damorgan_at_exesolutions.com> wrote:



>A table? A bit of a maintenance nightmare. Why not just:

>

>SELECT TO_NUMBER(TO_CHAR(SYSDATE, 'D') FROM dual;




A suitable table might be a one-time load, and it can answer all kinds
of temporal questions besides just this one.


-- 
Mike Sherrill
Information Management Systems


Received on Mon Feb 17 2003 - 13:30:22 CST












Original text of this message













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