OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » Sysdate Year

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Sysdate Year [message #1101]

Mon, 01 April 2002 09:18

Grey1
Messages: 3
Registered: April 2002

Junior Member

Is there a way I can pull just the current 4 digit year from sysdate?

Report message to a moderator

Re: Sysdate Year [message #1103 is a reply to message #1101]

Mon, 01 April 2002 09:32

Rawlings
Messages: 2
Registered: March 2002

Junior Member

SQL> select to_date(sysdate,'MM/DD/YYYY')from dual;

TO_DATE(SY
----------
04/01/2002

or if you just want the date, you could;
SQL> select substr(to_char(sysdate,'MMDDYYYY'),5,4) from dual;

SUBS
----
2002

Report message to a moderator

Re: Sysdate Year [message #1107 is a reply to message #1101]

Mon, 01 April 2002 18:24

Srinivas
Messages: 138
Registered: June 2000

Senior Member

Try this:-
select to_char(sysdate,'YYYY') from dual

Report message to a moderator

Previous Topic:	Re: How to find the Size of the Database? - Urgent.
Next Topic:	to store the sql st in d/b

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 08:07:59 CDT 2024