OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » extract date

Wed, 01 May 2002 02:25

casper
Messages: 3
Registered: May 2002

Junior Member

How can I extract parts of a day in a query (the month for example)?

Thanks.

Wed, 01 May 2002 03:50

John R
Messages: 156
Registered: March 2000

Senior Member

Just change the format mask that you use.

For Example:

To get the month and year, you could use:

SELECT to_char(sysdate,'Month yyyy') FROM dual;

Previous Topic:	Select Into - Nulls
Next Topic:	About Function

Goto Forum:

]

Current Time: Thu Apr 25 07:21:40 CDT 2024