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 March 14, 2011 * SQL help again < Previous Next >

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

Gochi
Bewarse Legend
Username: Gochi

Post Number: 72015
Registered: 07-2004
Posted From: 148.168.127.10

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

Posted on Monday, March 14, 2011 - 3:27 pm:    Edit Post Delete Post View Post/Check IP
420:

Gwwochaali thats DB2 for u



eppudo sinnappudu work chesina DB2...thappulemanna unte chaminchandi penkankul

MOVIEART--bemmi.adi
bongulo signature...manaki avasaramaaa CLIPART--eyebrow_raised_in_disbelief
Top of pagePrevious messageNext messageBottom of page Link to this message

420
Bewarse Legend
Username: 420

Post Number: 10992
Registered: 12-2006
Posted From: 212.238.45.228

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

Posted on Monday, March 14, 2011 - 2:43 pm:    Edit Post Delete Post View Post/Check IP
Gwwochaali thats DB2 for u
Knit India,do not split India !
Top of pagePrevious messageNext messageBottom of page Link to this message

Biryani
Kurra Bewarse
Username: Biryani

Post Number: 935
Registered: 10-2010
Posted From: 167.121.100.1

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

Posted on Monday, March 14, 2011 - 2:42 pm:    Edit Post Delete Post View Post/Check IP
Gochi:


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

Gochi
Bewarse Legend
Username: Gochi

Post Number: 72014
Registered: 07-2004
Posted From: 148.168.127.10

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

Posted on Monday, March 14, 2011 - 2:41 pm:    Edit Post Delete Post View Post/Check IP
Biryani:

select current date + 1 days - day(current date) days - 11 MONTH
from sysibm.sysdummy1



code raasinodikkadike artham aithe saripodhu...paina oka comment thagaleyyi...

MOVIEART--bemmi.angry
bongulo signature...manaki avasaramaaa CLIPART--eyebrow_raised_in_disbelief
Top of pagePrevious messageNext messageBottom of page Link to this message

Biryani
Kurra Bewarse
Username: Biryani

Post Number: 934
Registered: 10-2010
Posted From: 167.121.100.1

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

Posted on Monday, March 14, 2011 - 2:34 pm:    Edit Post Delete Post View Post/Check IP
thnxs

select current date + 1 days - day(current date) days - 11 MONTH
from sysibm.sysdummy1

vachindi
Top of pagePrevious messageNext messageBottom of page Link to this message

Dobbey
Pilla Bewarse
Username: Dobbey

Post Number: 142
Registered: 03-2011
Posted From: 170.136.110.10

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

Posted on Monday, March 14, 2011 - 2:29 pm:    Edit Post Delete Post View Post/Check IP
Gochi:

MOVIEART--ali.kummavga
Top of pagePrevious messageNext messageBottom of page Link to this message

Black_pearl
Mudiripoyina Bewarse
Username: Black_pearl

Post Number: 2950
Registered: 05-2010
Posted From: 212.159.240.81

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

Posted on Monday, March 14, 2011 - 1:10 pm:    Edit Post Delete Post View Post/Check IP
Gochi:

same finch penkulesh



Thanks to our bedars .. I am still in touch with SQL ..
UTTHAMA ABHIRUCHI Association Pessident ..
Top of pagePrevious messageNext messageBottom of page Link to this message

Gochi
Bewarse Legend
Username: Gochi

Post Number: 72009
Registered: 07-2004
Posted From: 148.168.127.10

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

Posted on Monday, March 14, 2011 - 1:08 pm:    Edit Post Delete Post View Post/Check IP
Black_pearl:

select LAST_DAY(DateField)+ 1 from dual



same finch penkulesh

MOVIEART--masa
bongulo signature...manaki avasaramaaa CLIPART--eyebrow_raised_in_disbelief
Top of pagePrevious messageNext messageBottom of page Link to this message

Gochi
Bewarse Legend
Username: Gochi

Post Number: 72008
Registered: 07-2004
Posted From: 148.168.127.10

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

Posted on Monday, March 14, 2011 - 1:07 pm:    Edit Post Delete Post View Post/Check IP
Biryani:

current month March 2011 ayithe na date field 1st April 2010 avvali.



Oracle aithe last_day(date) vaadithe month end vasthundi....so daaniki 1 day add chesi 12 months minus cheyyi...

select add_months((last_day(sysdate) + 1),-12) from dual

sysdate place lo neekkaavalsina date field ettuko
bongulo signature...manaki avasaramaaa CLIPART--eyebrow_raised_in_disbelief
Top of pagePrevious messageNext messageBottom of page Link to this message

Black_pearl
Mudiripoyina Bewarse
Username: Black_pearl

Post Number: 2949
Registered: 05-2010
Posted From: 212.159.240.81

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

Posted on Monday, March 14, 2011 - 1:02 pm:    Edit Post Delete Post View Post/Check IP
select LAST_DAY(DateField)+ 1 from dual

MOVIEART--banthi
UTTHAMA ABHIRUCHI Association Pessident ..
Top of pagePrevious messageNext messageBottom of page Link to this message

Proofdada
Bewarse Legend
Username: Proofdada

Post Number: 92133
Registered: 03-2004
Posted From: 62.178.194.192

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

Posted on Monday, March 14, 2011 - 12:42 pm:    Edit Post Delete Post View Post/Check IP
minus cheyyamanna ga andhukee...


month+1 cheesi year-1 cheesthe sari...

day kooda importenta?

then fn rayalemo
Top of pagePrevious messageNext messageBottom of page Link to this message

Biryani
Kurra Bewarse
Username: Biryani

Post Number: 933
Registered: 10-2010
Posted From: 167.121.100.1

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

Posted on Monday, March 14, 2011 - 12:38 pm:    Edit Post Delete Post View Post/Check IP
Proofdada:



ee roju date 2011/03/14 ayithe appudu 2010/04/15 vasthadi kada..

naku 2010/04/01 kavali
Top of pagePrevious messageNext messageBottom of page Link to this message

Proofdada
Bewarse Legend
Username: Proofdada

Post Number: 92131
Registered: 03-2004
Posted From: 62.178.194.192

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

Posted on Monday, March 14, 2011 - 12:35 pm:    Edit Post Delete Post View Post/Check IP
%4 = 0 0r not leap year test seesi -364/365 sesthe poddi ga...MOVIEART--lakalaka
Top of pagePrevious messageNext messageBottom of page Link to this message

Biryani
Kurra Bewarse
Username: Biryani

Post Number: 932
Registered: 10-2010
Posted From: 167.121.100.2

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

Posted on Monday, March 14, 2011 - 12:32 pm:    Edit Post Delete Post View Post/Check IP
nenu oka date field calculate cheyyali.

current month March 2011 ayithe na date field 1st April 2010 avvali.

kosintha help cheyyandi

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