OraFAQ Forum: Server Administration » How can I select only month?

Home » RDBMS Server » Server Administration » How can I select only month?

Wed, 07 March 2001 02:42

Karri Lahtela
Messages: 16
Registered: November 2000

Junior Member

Hi

How can I select month in column date?
Format of month should be in numbers (JAN->1 FEB->2...)
Format in database is dd-mmm-yy

BR Karri

Wed, 07 March 2001 03:12

John R
Messages: 156
Registered: March 2000

Senior Member

Select to_char(date_column,'mm') From table

Previous Topic:	Re: recordcount????
Next Topic:	storing code file

Goto Forum:

]

Current Time: Tue Jun 11 02:26:52 CDT 2024