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 -> date functions

date functions

From: steve hendrikse <shendrik_at_ebtech.net>
Date: Mon, 3 Jan 2000 16:52:18 -0500
Message-ID: <946936480.116279408@news.ebtech.net>


hi,

how can i select sections, like the month, day, or year from a date? if i do a "select sysdate from dual" then i get the complete date. now i want only the month or day? of course, how can i select only a portion of a date that is stored in a data column?

thanks in advance,
steve Received on Mon Jan 03 2000 - 15:52:18 CST

Original text of this message

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