| Author | Message | ||
Gharshana Side Hero Username: Gharshana Post Number: 2128 Registered: 07-2010 Posted From: 1.23.211.162 Rating: N/A |
Hey twitter babu.. you can use case statement in the where condition to get the dates of the present quater.. | ||
Megastar Username: Twitter Post Number: 26133 Registered: 10-2009 Posted From: 192.193.216.147 Rating: N/A |
useful ..thx | ||
Gharshana Side Hero Username: Gharshana Post Number: 2126 Registered: 07-2010 Posted From: 1.23.211.162 Rating: N/A |
Oh quarter lo anni dates kavala... sorry na query work avadu.. | ||
Megastar Username: Twitter Post Number: 26132 Registered: 10-2009 Posted From: 199.67.138.42 Rating: N/A |
ehe already visited nenu ani septhunna. | ||
Megastar Username: Twitter Post Number: 26131 Registered: 10-2009 Posted From: 199.67.138.42 Rating: N/A |
yep this can be softcoded with addmonths func. this is what i did in conjunction with my original qry..thx | ||
Gharshana Side Hero Username: Gharshana Post Number: 2125 Registered: 07-2010 Posted From: 1.23.211.162 Rating: N/A |
This would help: select aa as MONTH_NUMBER, (case when aa < 4 then 'FIRST QUARTER' when aa < 7 then 'SECOND QUARTER' when aa < 10 then 'THIRD QUARTER' else 'FOURTH QUARTER' END) as QUARTER from ( select to_char(sysdate, 'MM') aa from dual); To test it for other quaters: select aa as MONTH_NUMBER, (case when aa < 4 then 'FIRST QUARTER' when aa < 7 then 'SECOND QUARTER' when aa < 10 then 'THIRD QUARTER' else 'FOURTH QUARTER' END) as QUARTER from ( select to_char(to_date('16-DEC-2013','DD-MON-YYYY'), 'MM') aa from dual); The easiest way is to use Q format if you are just looking for the number: select to_char(sysdate, 'Q') aa from dual; | ||
Jambalahaart_raja Side Hero Username: Jambalahaart_raja Post Number: 2181 Registered: 07-2008 Posted From: 199.43.48.130 Rating: N/A |
isit sesindh nuvvu kaadh, nenh!!! red endukochhinayo idea ledh!!! | ||
Buduguuu Hero Username: Buduguuu Post Number: 12368 Registered: 01-2012 Posted From: 199.249.176.251 Rating: N/A |
select to_date('01-jan-2013','dd-mon-yyyy') + rownum -1 from all_objects where rownum <= to_date('31-mar-2013','dd-mon-yyyy')-to_date('01-jan-2013',' dd-mon-yyyy')+1 this is exact query  Coolmac : nanu comment sesey staayi ledhu neeku Biryani about Mahesh Babu | ||
Megastar Username: Twitter Post Number: 26127 Registered: 10-2009 Posted From: 192.193.216.147 Rating: N/A |
yeah undhi adhe chesthunna kani q's info ledhu ..sql lo emanna builtin fn's unnayemo ani oka stone esa.. | ||
Megastar Username: Twitter Post Number: 26126 Registered: 10-2009 Posted From: 192.193.216.147 Rating: N/A |
http://www.chalanachithram.com/discus/icons/quote3.gif vaddhule bedar i figured it out. anni dates oka chota petti querying sethunna..thx for the help | ||
Maverick Legend Username: Maverick Post Number: 44051 Registered: 01-2008 Posted From: 70.39.231.164 Rating: N/A |
general ga calendar table untundi kada mee environment lo..daniki join katti lagu Who is this DB member? | ||
Buduguuu Hero Username: Buduguuu Post Number: 12367 Registered: 01-2012 Posted From: 199.249.176.251 Rating: N/A |
direct sql lo teleed kaani pl/sql lo aite seyyach.. etiki septan Coolmac : nanu comment sesey staayi ledhu neeku Biryani about Mahesh Babu | ||
Megastar Username: Twitter Post Number: 26125 Registered: 10-2009 Posted From: 192.193.171.152 Rating: N/A |
rendu linkulu red ga unnai ante already visited  ..thx anywya | ||
Jambalahaart_raja Side Hero Username: Jambalahaart_raja Post Number: 2179 Registered: 07-2008 Posted From: 199.43.32.85 Rating: N/A |
vopaali idi soodudi http://stackoverflow.com/questions/6489923/calculate-fiscal- year-and-quarter http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUES TION_ID:250288900346075009 Hope this will help you figure out your own query | ||
Megastar Username: Twitter Post Number: 26122 Registered: 10-2009 Posted From: 199.67.131.151 Rating: N/A |
oka year lo 4 qtrs untai kadha .. suppose ivvala date input isthe naku ee qtr lo gadichina dates jan1 to tilldate anni kaavali. alage suppose April 15th date isthe appudu second qtr first nundi ante apr1st to 15 anni dates ivvali | ||
Buduguuu Hero Username: Buduguuu Post Number: 12349 Registered: 01-2012 Posted From: 199.249.176.251 Rating: N/A |
waaat?? kochen clarity led.. malli adagandi Coolmac : nanu comment sesey staayi ledhu neeku Biryani about Mahesh Babu | ||
Megastar Username: Twitter Post Number: 26120 Registered: 10-2009 Posted From: 199.67.131.151 Rating: N/A |
sysdate theeskoni ee qtr lo dates anni icche qry edhanna unte ivvandi babailu.. |