Home » SQL & PL/SQL » SQL & PL/SQL » month(date)>
month(date)> [message #9807] Fri, 05 December 2003 03:53 Go to next message
resy
Messages: 86
Registered: December 2003
Member
Is thr any function to extract only the month of a date?

thanx

Report message to a moderator

Re: month(date)> [message #9808 is a reply to message #9807] Fri, 05 December 2003 03:56 Go to previous messageGo to next message
Daljit Singh
Messages: 290
Registered: October 2003
Location: Texas
Senior Member
Hi,

Use which ever u want:

select to_char(sysdate,'month') "Month" from dual

select to_char(sysdate,'MONTH') "Month" from dual

select to_char(sysdate,'Month') "Month" from dual

select to_char(sysdate,'mm') "Month" from dual

select to_char(sysdate,'mmth') "Month" from dual

Report message to a moderator

Re: month(date)> [message #9809 is a reply to message #9808] Fri, 05 December 2003 04:01 Go to previous messageGo to next message
resy
Messages: 86
Registered: December 2003
Member
thanx a lot for the immediate reply.
:)

Report message to a moderator

Re: month(date)> [message #9811 is a reply to message #9807] Fri, 05 December 2003 05:14 Go to previous message
William Robertson
Messages: 1643
Registered: August 2003
Location: London, UK
Senior Member
There is also EXTRACT:

SELECT EXTRACT (MONTH FROM SYSDATE) FROM dual;

However TO_CHAR is probably more flexible.

Report message to a moderator

Previous Topic: Problem in procedure
Next Topic: SQL
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 25 12:41:23 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.