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

Oracle date functions

From: angshu <angshu_at_agnisoft.com>
Date: Thu, 29 Nov 2001 12:25:04 +0530
Message-ID: <9u5ou1$igd$1@news.vsnl.net.in> 





Hi, ... this might be very trival to all but I don't know
how to get the month, day or year from a date!
Is there anything like Month( ) , Day ( ) ?
Or do I have to do to_char(pDate,'MM') and then convert to
integer?



TIA



~angshu
Received on Thu Nov 29 2001 - 00:55:04 CST












Original text of this message













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