Oracle Sql Helf..!

[chinni005]

[quote name='Little Star' timestamp='1363098953' post='1303408784']
nee guddi G..kanipisthane undi kada
[/quote]

[chinni005]

aa ipudu inko error osthundhi..!
date not valid for specified month anta

idhedhi FEB daggara thanthundhi ani na feeling.. pls help..!


ORA-01839: date not valid for month specified
01839. 00000 - "date not valid for month specified"
*Cause:
*Action:

[mettastar]

[quote name='RockStarr' timestamp='1363099361' post='1303408809']
aa ipudu inko error osthundhi..!
date not valid for specified month anta

idhedhi FEB daggara thanthundhi ani na feeling.. pls help..!


ORA-01839: date not valid for month specified
01839. 00000 - "date not valid for month specified"
*Cause:
*Action:
[/quote]

I never saw using Between in select... epudu where Clause lo ne vadatharu anukunna to select between some range...

[chinni005]

[quote name='mettastar' timestamp='1363099606' post='1303408824']
I never saw using Between in select... epudu where Clause lo ne vadatharu anukunna to select between some range...
[/quote]
abbha adhi query lo oka line mayya parts parts ga copy chesi ala vesanu u can ignore query after between

[mettastar]

SELECT (((NVL(TO_date(BIRTH_DATE,'DD-MON-YYYY'),'19-JAN-1000')
+ to_yminterval('18-00') ))) FROM person
WHERE (((NVL(TO_date(BIRTH_DATE,'DD-MON-YYYY'),'19-JAN-1000')
+ to_yminterval('18-00') )))
BETWEEN (TRUNC(SYSDATE) + 30) AND (TRUNC(SYSDATE + 31))


idhi naaku run aindhi... i replaced BIRTH_DATE with sysdate for testing

[chinni005]

[quote name='mettastar' timestamp='1363099979' post='1303408860']
SELECT (((NVL(TO_date(BIRTH_DATE,'DD-MON-YYYY'),'19-JAN-1000')
+ to_yminterval('18-00') ))) FROM person
WHERE (((NVL(TO_date(BIRTH_DATE,'DD-MON-YYYY'),'19-JAN-1000')
+ to_yminterval('18-00') )))
BETWEEN (TRUNC(SYSDATE) + 30) AND (TRUNC(SYSDATE + 31))


idhi naaku run aindhi... i replaced BIRTH_DATE with sysdate for testing
[/quote]
nenu ice birth_date lo null values unnayi mama andhuke NVL use chesthunna

[chinni005]

[mettastar]

[quote name='RockStarr' timestamp='1363100152' post='1303408875']
nenu ice birth_date lo null values unnayi mama andhuke NVL use chesthunna
[/quote]
ya ardhamaindhi..
naku atlanti data ledhu kada to test..
nee updated SQL and error motham ikkda post cheyi

[chinni005]

oka person unnadu..!

vaadi DOB enter chesa..! MM/DD/YYYY

enter chesina DOB ki 18 years oche 1 month mundhu..! person table lo values em ayina unnyemo kavali..!

idi requirement ..!

[chinni005]

[quote name='mettastar' timestamp='1363100587' post='1303408930']
ya ardhamaindhi..
naku atlanti data ledhu kada to test..
nee updated SQL and error motham ikkda post cheyi
[/quote]
mama metta* rock * payina requirement post chesadu chudu..!

[mettastar]

dude nee paatha ID enti?? do i know u?

[mettastar]

SELECT TO_date(BIRTH_DATE,'DD-MON-YYYY') DOB, NVL(TO_date(BIRTH_DATE,'DD-MON-YYYY'),'19-JAN-1000') + to_yminterval('18-00') DOB_18
FROM person
WHERE EX_DATE BETWEEN TO_date(BIRTH_DATE,'DD-MON-YYYY') AND
NVL(TO_date(BIRTH_DATE,'DD-MON-YYYY'),'19-JAN-1000') + to_yminterval('18-00') -30

idi chudu

EX_DATE anedi table lo record insert chesina date... adi nee table lo edaithe adi pettu..
naaku ardhamaina daani prakaaram...
if DOB=12-MAR-2013 and DOB18=12-MAR-31 then neeku between DOB and DOB18-30days lopu unna records anni kaavali ??

[chinni005]

[quote name='mettastar' timestamp='1363100654' post='1303408941']
dude nee paatha ID enti?? do i know u?
[/quote]
what is ur old doddd

[iTeachSAP]

toad vaadu bayya.. nuvvu format click chesthe.. it will show you where the error is.. its easier to do ..

[bmwx3]

[quote name='Silence..Please' timestamp='1363098954' post='1303408785']
try shutdown abort; command at the end of your sql .. everything will resolve
[/quote]
house teesi dba privs unte