Home » RDBMS Server » Server Administration » year only date format
year only date format [message #52708] Wed, 07 August 2002 15:00 Go to next message
eb
Messages: 1
Registered: August 2002
Junior Member
How can I store a year only ('YYYY') value in a date field? Also need to be able to store month and year only as well ('MM-YYYY').

Database configuration?

Thanks.

Report message to a moderator

Re: year only date format [message #52719 is a reply to message #52708] Thu, 08 August 2002 02:50 Go to previous message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
do a to_date(mydatecol,'mm-yyyy')
or
save the date as varchar2!!
to_char(mydatecol,'mm-yyyy');

Report message to a moderator

Previous Topic: Change Database monitor timeout value ORA-01013
Next Topic: Recovery Schemes used in Oracle
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 26 07:02:18 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.