OraFAQ Forum: SQL & PL/SQL » to get no. of days from 1900 to current date

Home » SQL & PL/SQL » SQL & PL/SQL » to get no. of days from 1900 to current date

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

to get no. of days from 1900 to current date [message #21692]

Fri, 23 August 2002 02:49

meena
Messages: 36
Registered: December 2000

Member

Is a built in function to find no. of days from 1900 to current date in pro*c

Please help

Thanks in advance
meena

Report message to a moderator

Re: to get no. of days from 1900 to current date [message #21697 is a reply to message #21692]

Fri, 23 August 2002 06:21

Venky
Messages: 52
Registered: October 2001

Member

select trunc(sysdate) - to_date('01-JAN-1900','DD-MON-RRRR') days from dual
SQL> /

DAYS
----------
37489

Trunc(sysdate) is required because depending upon server setting it may contain time component.

Report message to a moderator

Previous Topic:	select count(1)
Next Topic:	Re: optimizing sql statement

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed May 08 10:01:14 CDT 2024