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-2010 * Cine Talk - Reviews, Gossips, Insider Info etc. * Archive through May 03, 2010 * Oracle gurus < Previous Next >

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

Sensation
Yavvanam Kaatesina Bewarse
Username: Sensation

Post Number: 2140
Registered: 12-2004
Posted From: 98.192.8.71

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

Posted on Friday, July 17, 2009 - 11:50 am:    Edit Post Delete Post View Post/Check IP

when you use to_date function, you tell the format in which you are sending the data.
Top of pagePrevious messageNext messageBottom of page Link to this message

Sensation
Yavvanam Kaatesina Bewarse
Username: Sensation

Post Number: 2139
Registered: 12-2004
Posted From: 98.192.8.71

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

Posted on Friday, July 17, 2009 - 11:48 am:    Edit Post Delete Post View Post/Check IP

select value from v$parameter where name='nls_date_format'

That will tell you in which format you have to give the date in where clause.

Safe way to do is

select * from table_name where datecolumn=to_date('17-JUL-2009','DD-MON-YYYY')
Top of pagePrevious messageNext messageBottom of page Link to this message

Bignole
Celebrity Bewarse
Username: Bignole

Post Number: 8943
Registered: 03-2004
Posted From: 161.225.129.111

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

Posted on Friday, July 17, 2009 - 11:32 am:    Edit Post Delete Post View Post/Check IP

nayak baa,nuvvu mapping ki ekkuva mapplet ki thakkuva
Anni vunna vadiki chavante bhayam...anni vadulukunna vadiki brathukante bhayam
Top of pagePrevious messageNext messageBottom of page Link to this message

Gochi
Bewarse Legend
Username: Gochi

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

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

Posted on Friday, July 17, 2009 - 10:36 am:    Edit Post Delete Post View Post/Check IP

nayak baa,nuvvu mapping ki ekkuva mapplet ki thakkuva...unconnected lookup type face esukuni oracle thedloki acchesaava


Gosi gaadu seppina maate malli seppadu,anduke signature ettadu
Top of pagePrevious messageNext messageBottom of page Link to this message

Ravanabrahma
Bewarse Legend
Username: Ravanabrahma

Post Number: 11185
Registered: 06-2004
Posted From: 65.196.167.82

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

Posted on Friday, July 17, 2009 - 10:35 am:    Edit Post Delete Post View Post/Check IP

Top of pagePrevious messageNext messageBottom of page Link to this message

310
Kurra Bewarse
Username: 310

Post Number: 809
Registered: 12-2006
Posted From: 138.32.32.166

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

Posted on Friday, July 17, 2009 - 10:29 am:    Edit Post Delete Post View Post/Check IP

GOSI apavoo inkaaa extras ekkuva ayyay ee madhyana neeku
Top of pagePrevious messageNext messageBottom of page Link to this message

Nelsonmandela
Celebrity Bewarse
Username: Nelsonmandela

Post Number: 5680
Registered: 09-2006
Posted From: 67.132.206.254

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

Posted on Friday, July 17, 2009 - 10:20 am:    Edit Post Delete Post View Post/Check IP


Gochi:




thanks gosi baa naa manam kapadav
5 years 50 lakhs
Top of pagePrevious messageNext messageBottom of page Link to this message

Gochi
Bewarse Legend
Username: Gochi

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

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

Posted on Friday, July 17, 2009 - 10:07 am:    Edit Post Delete Post View Post/Check IP


Aggi_pidugu:

oke table lo oka column lo rondu version madya 3-7 fields change ayyai emo chustaniki string use selfjoin to compare seyyacha?




konchen artham kaaledhu...koosintha example isthaava appesh...
Gosi gaadu seppina maate malli seppadu,anduke signature ettadu
Top of pagePrevious messageNext messageBottom of page Link to this message

Dash
Mudiripoyina Bewarse
Username: Dash

Post Number: 2558
Registered: 02-2009
Posted From: 72.198.204.216

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

Posted on Friday, July 17, 2009 - 10:05 am:    Edit Post Delete Post View Post/Check IP


Gochi:




Top of pagePrevious messageNext messageBottom of page Link to this message

310
Kurra Bewarse
Username: 310

Post Number: 807
Registered: 12-2006
Posted From: 138.32.32.166

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

Posted on Friday, July 17, 2009 - 10:03 am:    Edit Post Delete Post View Post/Check IP

naa appi naa pedaa
Top of pagePrevious messageNext messageBottom of page Link to this message

Aggi_pidugu
Bewarse Legend
Username: Aggi_pidugu

Post Number: 26812
Registered: 05-2006
Posted From: 12.168.68.11

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

Posted on Friday, July 17, 2009 - 9:57 am:    Edit Post Delete Post View Post/Check IP

oke table lo oka column lo rondu version madya 3-7 fields change ayyai emo chustaniki string use selfjoin to compare seyyacha?
kamaturanam na tingu na rangu - Italian mafioso
Top of pagePrevious messageNext messageBottom of page Link to this message

Gochi
Bewarse Legend
Username: Gochi

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

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

Posted on Friday, July 17, 2009 - 9:44 am:    Edit Post Delete Post View Post/Check IP


Ravanabrahma:

trunc(date) = trunc(sysdate)





Gosi gaadu seppina maate malli seppadu,anduke signature ettadu
Top of pagePrevious messageNext messageBottom of page Link to this message

Ravanabrahma
Bewarse Legend
Username: Ravanabrahma

Post Number: 11184
Registered: 06-2004
Posted From: 65.196.167.82

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

Posted on Friday, July 17, 2009 - 9:43 am:    Edit Post Delete Post View Post/Check IP

select * from tablename where trunc(date) = trunc(sysdate)

anu ee roju date vi kavalante...
Top of pagePrevious messageNext messageBottom of page Link to this message

Gochi
Bewarse Legend
Username: Gochi

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

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

Posted on Friday, July 17, 2009 - 9:30 am:    Edit Post Delete Post View Post/Check IP


Nelsonmandela:

select * from datetable where date =' '
idhi correst query naa? date loo ee format loo ettali?




select * from tablename where trunc(date) = '17-JUN-2009'
Gosi gaadu seppina maate malli seppadu,anduke signature ettadu
Top of pagePrevious messageNext messageBottom of page Link to this message

Naatu
Yavvanam Kaatesina Bewarse
Username: Naatu

Post Number: 1695
Registered: 03-2004
Posted From: 192.44.136.113

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

Posted on Friday, July 17, 2009 - 9:29 am:    Edit Post Delete Post View Post/Check IP


Nelsonmandela:


idhi correst query naa? date loo ee format loo ettali?




teliyaadu
PRP R.I.P
Top of pagePrevious messageNext messageBottom of page Link to this message

Nelsonmandela
Celebrity Bewarse
Username: Nelsonmandela

Post Number: 5679
Registered: 09-2006
Posted From: 67.132.206.254

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

Posted on Friday, July 17, 2009 - 9:27 am:    Edit Post Delete Post View Post/Check IP

select * from datetable where date =' '

idhi correst query naa? date loo ee format loo ettali?
5 years 50 lakhs
Top of pagePrevious messageNext messageBottom of page Link to this message

Gochi
Bewarse Legend
Username: Gochi

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

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

Posted on Friday, July 17, 2009 - 9:26 am:    Edit Post Delete Post View Post/Check IP

em date....timestamp ni date gaa convert seyyaala...BA's lekka artham kaani requirement isthaava


Gosi gaadu seppina maate malli seppadu,anduke signature ettadu
Top of pagePrevious messageNext messageBottom of page Link to this message

Nelsonmandela
Celebrity Bewarse
Username: Nelsonmandela

Post Number: 5678
Registered: 09-2006
Posted From: 67.132.206.254

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

Posted on Friday, July 17, 2009 - 9:24 am:    Edit Post Delete Post View Post/Check IP

table nunchi date retreive query endhi?
5 years 50 lakhs

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