| Author |
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: |
|
when you use to_date function, you tell the format in which you are sending the data. |
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: |
|
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') |
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: |
|
nayak baa,nuvvu mapping ki ekkuva mapplet ki thakkuva
Anni vunna vadiki chavante bhayam...anni vadulukunna vadiki brathukante bhayam
|
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: |
|
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 
|
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: |
|
 |
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: |
|
GOSI apavoo inkaaa extras ekkuva ayyay ee madhyana neeku  |
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: |
|
Gochi:
thanks gosi baa naa manam kapadav
5 years 50 lakhs
|
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: |
|
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
|
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: |
|
Gochi:
 |
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: |
|
naa appi naa pedaa |
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: |
|
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 
|
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: |
|
Ravanabrahma:trunc(date) = trunc(sysdate)
Gosi gaadu seppina maate malli seppadu,anduke signature ettadu
|
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: |
|
select * from tablename where trunc(date) = trunc(sysdate)
anu ee roju date vi kavalante... |
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: |
|
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
|
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: |
|
Nelsonmandela:
idhi correst query naa? date loo ee format loo ettali?
teliyaadu
PRP R.I.P
|
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: |
|
select * from datetable where date =' '
idhi correst query naa? date loo ee format loo ettali?
5 years 50 lakhs
|
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: |
|
em date....timestamp ni date gaa convert seyyaala...BA's lekka artham kaani requirement isthaava
Gosi gaadu seppina maate malli seppadu,anduke signature ettadu
|
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: |
|
table nunchi date retreive query endhi?
5 years 50 lakhs
|
Archives - 2009