Topics Topics Help/Instructions Help Edit Profile Profile Member List Register Paatha Gnyapakaalu - Archives from Old DB  
Search New Posts 1 | 2 | 8 Hours Search New Posts 1 | 3 | 7 Days Search Search Tree View Tree View Latest tweets Live Tweets
Bewarse Talk Discussion Board * Archives - 2011 * Cine Talk - Reviews, Gossips, Insider Info etc. * Archive through November 15, 2011 * SQL Question < Previous Next >

Author Message
Top of pagePrevious messageNext messageBottom of page Link to this message

Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma

Post Number: 17733
Registered: 06-2004
Posted From: 98.151.191.253

Rating: N/A
Votes: 0 (Vote!)

Posted on Saturday, November 12, 2011 - 1:00 pm:    Edit Post Delete Post View Post/Check IP
Gochi:



AND SUBSTR(PERIOD_NAME, 1, 3) != 'ADJ'

idi padesabaa..working good..thanks baa..
Top of pagePrevious messageNext messageBottom of page Link to this message

Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma

Post Number: 17732
Registered: 06-2004
Posted From: 98.151.191.253

Rating: N/A
Votes: 0 (Vote!)

Posted on Saturday, November 12, 2011 - 12:57 pm:    Edit Post Delete Post View Post/Check IP
Gochi:

nenu kooda morning nundi office work sesings..deenemma evo jobs fail ayi dobbinchukunnai productionlo



MOVIEART--abba neeku prathi weekend weekday nee laga undi baa.
Top of pagePrevious messageNext messageBottom of page Link to this message

Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma

Post Number: 17731
Registered: 06-2004
Posted From: 98.151.191.253

Rating: N/A
Votes: 0 (Vote!)

Posted on Saturday, November 12, 2011 - 12:57 pm:    Edit Post Delete Post View Post/Check IP
Gochi:

spaces pettuntaaru...trim() chesi choodu...



edo period_name ADJ-03 ala undi ba..ademo reason chosthunna..
Top of pagePrevious messageNext messageBottom of page Link to this message

Lambam
Pilla Bewarse
Username: Lambam

Post Number: 9
Registered: 10-2011
Posted From: 166.205.139.122

Rating: N/A
Votes: 0 (Vote!)

Posted on Saturday, November 12, 2011 - 12:57 pm:    Edit Post Delete Post View Post/Check IP
Gochi:


http://i42.tinypic.com/258qdu9.gif
Top of pagePrevious messageNext messageBottom of page Link to this message

Gochi
Bewarse Legend
Username: Gochi

Post Number: 75560
Registered: 07-2004
Posted From: 70.44.12.183

Rating: N/A
Votes: 0 (Vote!)

Posted on Saturday, November 12, 2011 - 12:56 pm:    Edit Post Delete Post View Post/Check IP
nenu kooda morning nundi office work sesings..deenemma evo jobs fail ayi dobbinchukunnai productionlo

MOVIEART--bemmi.frock
Top of pagePrevious messageNext messageBottom of page Link to this message

Gochi
Bewarse Legend
Username: Gochi

Post Number: 75559
Registered: 07-2004
Posted From: 70.44.12.183

Rating: N/A
Votes: 0 (Vote!)

Posted on Saturday, November 12, 2011 - 12:54 pm:    Edit Post Delete Post View Post/Check IP
Ravanabrahma:

.kakapothe gl_balances lo wrong data unnattundi..to_date(....) isthunte invalid month antundi



CLIPART--biggrin spaces pettuntaaru...trim() chesi choodu...
Top of pagePrevious messageNext messageBottom of page Link to this message

Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma

Post Number: 17730
Registered: 06-2004
Posted From: 98.151.191.253

Rating: N/A
Votes: 0 (Vote!)

Posted on Saturday, November 12, 2011 - 12:46 pm:    Edit Post Delete Post View Post/Check IP
Gochi:

to_date(x,'MON-YY') work avvatledhaaa hemesh



baa..nuvvu devudivi baa..its working..kakapothe gl_balances lo wrong data unnattundi..to_date(....) isthunte invalid month antundi MOVIEART--bemmi.frock
Top of pagePrevious messageNext messageBottom of page Link to this message

Gochi
Bewarse Legend
Username: Gochi

Post Number: 75558
Registered: 07-2004
Posted From: 70.44.12.183

Rating: N/A
Votes: 0 (Vote!)

Posted on Saturday, November 12, 2011 - 12:27 pm:    Edit Post Delete Post View Post/Check IP
to_date(x,'MON-YY') work avvatledhaaa hemesh
Top of pagePrevious messageNext messageBottom of page Link to this message

Pilla_zamindar
Pilla Bewarse
Username: Pilla_zamindar

Post Number: 555
Registered: 09-2011
Posted From: 166.195.35.87

Rating: N/A
Votes: 0 (Vote!)

Posted on Saturday, November 12, 2011 - 12:13 pm:    Edit Post Delete Post View Post/Check IP
Dobbey:

ante ayanaki teliyaka adigaadu anukunnavaMOVIEART--avataram
Top of pagePrevious messageNext messageBottom of page Link to this message

Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma

Post Number: 17729
Registered: 06-2004
Posted From: 98.151.191.253

Rating: N/A
Votes: 0 (Vote!)

Posted on Saturday, November 12, 2011 - 12:13 pm:    Edit Post Delete Post View Post/Check IP
Pilla_zamindar:

Inka answer seppeyi baaa



MOVIEART--bemmi.angry
Top of pagePrevious messageNext messageBottom of page Link to this message

Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma

Post Number: 17728
Registered: 06-2004
Posted From: 98.151.191.253

Rating: N/A
Votes: 0 (Vote!)

Posted on Saturday, November 12, 2011 - 12:12 pm:    Edit Post Delete Post View Post/Check IP
Dobbey:

bemmam bedar gl_periods table lo start_date , end_date untundi period ki adi try maadu



https://forums.oracle.com/forums/thread.jspa?threadID=1132550

ee thread lo similar answer icharu baa..kaani naa table vachi pa_draft_revenues_all indulo pa_period between anedi chodali..so ee table ni pa_periods_all ki join chesi andulo unna start date and end date tho chodochemo chostha aagu..
Top of pagePrevious messageNext messageBottom of page Link to this message

Dobbey
Kurra Bewarse
Username: Dobbey

Post Number: 3794
Registered: 03-2011
Posted From: 99.119.215.125

Rating: N/A
Votes: 0 (Vote!)

Posted on Saturday, November 12, 2011 - 12:06 pm:    Edit Post Delete Post View Post/Check IP
bemmam bedar gl_periods table lo start_date , end_date untundi period ki adi try maadu
Health is Happiness
Top of pagePrevious messageNext messageBottom of page Link to this message

Pilla_zamindar
Pilla Bewarse
Username: Pilla_zamindar

Post Number: 554
Registered: 09-2011
Posted From: 166.195.35.87

Rating: N/A
Votes: 0 (Vote!)

Posted on Saturday, November 12, 2011 - 12:06 pm:    Edit Post Delete Post View Post/Check IP
Inka answer seppeyi baaa
Top of pagePrevious messageNext messageBottom of page Link to this message

Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma

Post Number: 17727
Registered: 06-2004
Posted From: 98.151.191.253

Rating: N/A
Votes: 0 (Vote!)

Posted on Saturday, November 12, 2011 - 12:05 pm:    Edit Post Delete Post View Post/Check IP
oka table lo oka column undi period_name. daani values ila untay...JAN-11, FEB-11, MAR-11 etc...


naa query lo period_from and period_to undi. if I give period_from as JAN-11 and period_to as JUL-11, it should pick the records that has period_name from JAN-11 to JUL-11.

If I give period_name BETWEEN 'JAN-11' AND 'JUL-11' ante work avvatam ledu its not a number of someting. deenni ela handle cheyyali?

Topics | Last Hour | Last Day | Last Week | Tree View | Search | Help/Instructions | Program Credits Administration