| Author |
Message |
    
Stewie
Pilla Bewarse
Username: Stewie
Post Number: 775
Registered: 03-2011
Posted From: 67.188.48.139
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, December 06, 2011 - 11:21 pm: |
|
Dobbey:last_day function undani gosannai chebithe kaani telvaledu naku kooda
me 2 
kothga petta signature ela undi 
|
Dobbey
Kurra Bewarse
Username: Dobbey
Post Number: 4159
Registered: 03-2011
Posted From: 24.107.128.31
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, December 06, 2011 - 11:16 pm: |
|
last_day function undani gosannai chebithe kaani telvaledu naku kooda 
Health is Happiness
|
Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma
Post Number: 18060
Registered: 06-2004
Posted From: 98.151.191.253
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, December 06, 2011 - 11:05 pm: |
|
Dobbey:gl_periods lo period start_date,end_date untdi gaaa
idi gl_periods kadu baa..report parameters lo just period name isthuna..and project inv or revenue table views lo pa_date undi..that can be anywhere in the month..so pa_date between to_date(from_period) and to_date(to_period) ante 1st day of to_period lone chosthadi instead of last day..so last_day kavalsi vachindi annamata.. |
Dobbey
Kurra Bewarse
Username: Dobbey
Post Number: 4158
Registered: 03-2011
Posted From: 24.107.128.31
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, December 06, 2011 - 11:02 pm: |
|
gl_periods lo period start_date,end_date untdi gaaa 
Health is Happiness
|
Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma
Post Number: 18059
Registered: 06-2004
Posted From: 98.151.191.253
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, December 06, 2011 - 11:02 pm: |
|
it worked gochi ba..thanks ba..
ee time lo india batch untadi etta anukuna..nuvvu padukoleda ayithe..thanks baa |
Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma
Post Number: 18058
Registered: 06-2004
Posted From: 98.151.191.253
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, December 06, 2011 - 11:01 pm: |
|
Gochi:last_day(to_date(....) try cheyyi baa
ippude try sethanna ba ee link chosi.
http://www.java2s.com/Code/Oracle/Date-Timezone/LASTDAYGetthelastdayofeachmonth. htm
aagu try chesi cheptha..samayaniki cheppav..lekapothe malla ans cheppa ani kummesevallu.. |
Gochi
Bewarse Legend
Username: Gochi
Post Number: 75819
Registered: 07-2004
Posted From: 70.44.12.183
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, December 06, 2011 - 10:59 pm: |
|
last_day(to_date(....) try cheyyi baa |
Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma
Post Number: 18057
Registered: 06-2004
Posted From: 98.151.191.253
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, December 06, 2011 - 10:57 pm: |
|
Pilla_zamindar:
 |
Pilla_zamindar
Pilla Bewarse
Username: Pilla_zamindar
Post Number: 739
Registered: 09-2011
Posted From: 98.17.102.158
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, December 06, 2011 - 10:57 pm: |
|
Hemu I am Waiting por answer  |
Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma
Post Number: 18056
Registered: 06-2004
Posted From: 98.151.191.253
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, December 06, 2011 - 10:56 pm: |
|
I am using TO_DATE(:P_PERIOD_TO, 'MON-YY') to get the date. P_PERIOD_TO is JUL-11. the To_date function returns 01-JUL-11. But I want to get the last day of that period like 31-JUL-11. what function I should use. |
Archives - 2011