OraFAQ Forum: SQL & PL/SQL

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

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

date [message #38229]

Wed, 03 April 2002 08:49

Raju
Messages: 74
Registered: March 1999

Member

how to select the first date of the year
i mean 01/01/2002 through a select statement

Report message to a moderator

Re: date [message #38230 is a reply to message #38229]

Wed, 03 April 2002 08:53

Todd Barry
Messages: 4819
Registered: August 2001

Senior Member

select trunc(sysdate, 'y') from dual

Report message to a moderator

Re: date [message #38232 is a reply to message #38229]

Wed, 03 April 2002 09:04

Raju
Messages: 74
Registered: March 1999

Member

Thanks,
one last thing.

how to get last year this month through a select statement.

04/03/2001

Report message to a moderator

Re: date [message #38234 is a reply to message #38229]

Wed, 03 April 2002 10:58

Todd Barry
Messages: 4819
Registered: August 2001

Senior Member

select add_months(sysdate, -12) from dual

Report message to a moderator

Re: date [message #38352 is a reply to message #38229]

Fri, 12 April 2002 22:12

Alpesh Kothari
Messages: 7
Registered: April 2002

Junior Member

This is not worked
select add_months(sysdate, -12) from dual;

But u try following query
SELECT TRUNC(sysdate,'YEAR') FROM dual;
or
passing Date
SELECT TRUNC(TO_DATE('13-APR-01'),'YEAR') FROMdual;

Report message to a moderator

Previous Topic:	Update with variable in where clause
Next Topic:	How to obtain Rows affected in PL/SQL???

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 14:41:19 CDT 2024