Help In Oracle

[rapchik]

How to calculate date diffence between any date and system date.....


datediff vadina kani oracle lo adhi kadhu anukunta ple help ... [size=4] [/size][size=4] [/size]

[kiladi bullodu]

calling citi

ltt

[uravis]

Months_between function

[rakshakudu]

Sysdate ok...date means any table date or which date?

[mtkr]

oka saari to_char ki covert chesukoni try chei kaka... Nt sure exactly...

to_char(sysdate, 'yyyy/mm/dd') - to_char(datecolm,'yyyy/mm/dd')

if hrs lo kaavali ante multiply wth 24

[loveindia]

[quote name='ReddyGaru_' timestamp='1378764720' post='1304227157']
How to calculate date diffence between any date and system date.....


datediff vadina kani oracle lo adhi kadhu anukunta ple help ... [size=4] [/size]
[/quote]

[code]
select 24 * (to_date('2009-01-01 22:00', 'YYYY-MM-DD hh24:mi') - to_date('2009-10-01 22:00', 'YYYY-MM-DD hh24:mi')) as datediff
from dual;
[/code]

Source : Google

[SUbba LIngam]

[quote name='mtkr' timestamp='1378765423' post='1304227198']
oka saari to_char ki covert chesukoni try chei kaka... Nt sure exactly...

to_char(sysdate, 'yyyy/mm/dd') - to_char(datecolm,'yyyy/mm/dd')

if hrs lo kaavali ante multiply wth 24
[/quote]

char ki convert chesina tarvaata date diff etla vastadi vayya,,,,,,,,

@TS select sysdate - to_date(date, 'MM-DD-YYYY') from dual

[rapchik]

[quote name='SUbba LIngam' timestamp='1378766672' post='1304227251']
char ki convert chesina tarvaata date diff etla vastadi vayya,,,,,,,,

@TS select sysdate - to_date(date, 'MM-DD-YYYY') from dual
[/quote]
[quote name='loveindia' timestamp='1378765544' post='1304227208']
[code]
select 24 * (to_date('2009-01-01 22:00', 'YYYY-MM-DD hh24:mi') - to_date('2009-10-01 22:00', 'YYYY-MM-DD hh24:mi')) as datediff
from dual;
[/code]

Source : Google
[/quote]
[quote name='mtkr' timestamp='1378765423' post='1304227198']
oka saari to_char ki covert chesukoni try chei kaka... Nt sure exactly...

to_char(sysdate, 'yyyy/mm/dd') - to_char(datecolm,'yyyy/mm/dd')

if hrs lo kaavali ante multiply wth 24
[/quote]

select (sysdate - Anydate) from Table this works

[mtkr]

[quote name='SUbba LIngam' timestamp='1378766672' post='1304227251']
char ki convert chesina tarvaata date diff etla vastadi vayya,,,,,,,,

@TS select sysdate - to_date(date, 'MM-DD-YYYY') from dual
[/quote]


nen cheppinde crrt aithe NT SURE EXACTLY ani enduku pedtha bayya... jus a try for LTT for answered pple like u...

[mtkr]

[quote name='ReddyGaru_' timestamp='1378769294' post='1304227375']
select (sysdate - Anydate) from Table this works
[/quote]