| Author | Message | ||
     Padmasri Junior Artist Username: Padmasri Post Number: 685 Registered: 10-2011 Posted From: 72.101.222.22 Rating: N/A |
j4 tamud java loo solution sesi, sap loo remix sesi oracle loo feed seyi..it will work yaaa | ||
| Just4fun Megastar Username: Just4fun Post Number: 23518 Registered: 10-2007 Posted From: 166.137.141.254 Rating: N/A |
Sachhi, dt enter cheste aa date morning 8 to next day morning 8 varaku all records pull cheyali first post lo ettanuga.. @Cyber, problem solved Babai. Time congestion lo date kuda include chesa tannindi. | ||
| Sachin Megastar Username: Sachin Post Number: 26695 Registered: 04-2008 Posted From: 173.230.67.197 Rating: N/A |
j4f asalu em sadhinchali anukunnav nuvvu  | ||
| Cyberabadsinnodu Side Hero Username: Cyberabadsinnodu Post Number: 2026 Registered: 02-2010 Posted From: 166.137.141.84 Rating: N/A |
Select whatever colimns from AAA where enter date in between (1/1/11' dateformat) and (2/2/11,dateformat) ila rayoxhu or datetimeformat kuda untadi google lo chudandi ఎంత చికాగో యునివర్సిటీ లో చదువుకున్నా చిలక్కొట్టుడికి సరైన ఇంగ్లీషు పదం దొరుకుతుందా..!! | ||
| Just4fun Megastar Username: Just4fun Post Number: 23517 Registered: 10-2007 Posted From: 174.37.61.78 Rating: N/A |
Thank you all guys. ikkade tantondi..solved spl thx bro  | ||
| Hero Username: Twitter Post Number: 13110 Registered: 10-2009 Posted From: 151.191.175.206 Rating: N/A |
adhi sangathi aithe first to_char ki maarchi tharvatha to_date cheyyi eg:to_date(to_char(dtcolumn,'mm/dd/yyyy'),'mm/dd/yyyy')) | ||
| Just4fun Megastar Username: Just4fun Post Number: 23516 Registered: 10-2007 Posted From: 174.37.61.78 Rating: N/A |
inkoti nee variable type enti string ena ?>>>>>>> entereddate - date enteredtime - varchar(string) | ||
| Simpletruth Side Hero Username: Simpletruth Post Number: 3826 Registered: 02-2010 Posted From: 71.255.239.73 Rating: N/A |
Entered time vunna chota date petti emiti. Akkada column name undali. Select * from AAA where todate(tochar(entereddate, 'dd/mm/yyyy format') || ' ' || tochar(enteredtime, 'hh:mm:ss format') , ) between start date and End date 1st round: puli vs Khaleja vs Orange vs PVC --- Winner Mahesh 2nd round: Teenmar vs Dookudu vs racha(???) vs SRR -- Winner Mahesh (Pending Racha Result) | ||
| Hero Username: Twitter Post Number: 13109 Registered: 10-2009 Posted From: 151.191.175.206 Rating: N/A |
idhi avasaram ledhu nuv edhi enter chesina converting ito 24hrs format . inkoti nee variable type enti string ena ? | ||
| Just4fun Megastar Username: Just4fun Post Number: 23515 Registered: 10-2007 Posted From: 174.37.61.78 Rating: N/A |
SELECT * FROM AAA WHERE '11/15/2011 08:00:00 AM' between TO_DATE(entereddate,'mm/dd/yyyy HH12:MI:SS AM') AND TO_DATE(entereddate+1,'mm/dd/yyyy HH12:MI:SS AM') ila marcha babai not working .. | ||
| Hero Username: Twitter Post Number: 13107 Registered: 10-2009 Posted From: 151.191.175.206 Rating: N/A |
na query lo dates maarchu ko neeku thaggattuga | ||
| Just4fun Megastar Username: Just4fun Post Number: 23514 Registered: 10-2007 Posted From: 174.37.61.78 Rating: N/A |
ade kada babai nenu rasindi..invalid number ani error vastondi | ||
| Hero Username: Twitter Post Number: 13106 Registered: 10-2009 Posted From: 151.191.175.206 Rating: N/A |
SELECT * FROM AAA WHERE xdate between TO_DATE('11/15/2011 08:00:00','mm/dd/yyyy HH24:MI:SS') AND TO_DATE('11/15/2011 06:00:00','mm/dd/yyyy HH24:MI:SS') | ||
| Simpletruth Side Hero Username: Simpletruth Post Number: 3825 Registered: 02-2010 Posted From: 71.255.239.73 Rating: N/A |
2 dates ni overt cheyyalevu ga. Rough ga To date ( To char(entereddate) + ' ' + to char (entered time)) Between start date and end date 1st round: puli vs Khaleja vs Orange vs PVC --- Winner Mahesh 2nd round: Teenmar vs Dookudu vs racha(???) vs SRR -- Winner Mahesh (Pending Racha Result) | ||
| Just4fun Megastar Username: Just4fun Post Number: 23513 Registered: 10-2007 Posted From: 174.37.61.78 Rating: N/A |
select * from AAA where to_date(TO_CHAR('15-NOV-2011','DD-MON-RRRR')||' '||'15-NOV-2011 08:00:00 AM','DD-MON-RRRR HH12:MI:SS AM') between TO_DATE(TO_CHAR(entereddate,'DD-MON-RRRR')||' '||'06:00:00 AM','DD-MON-RRRR HH12:MI:SS AM') and TO_DATE(TO_CHAR(entereddate+1,'DD-MON-RRRR')||' '||'06:00:00 AM','DD-MON-RRRR HH12:MI:SS AM') error vastondi | ||
| Simpletruth Side Hero Username: Simpletruth Post Number: 3822 Registered: 02-2010 Posted From: 71.255.239.73 Rating: N/A |
2 columns concat chesi date a convert chesi petti where clause lo 1st round: puli vs Khaleja vs Orange vs PVC --- Winner Mahesh 2nd round: Teenmar vs Dookudu vs racha(???) vs SRR -- Winner Mahesh (Pending Racha Result) | ||
| Just4fun Megastar Username: Just4fun Post Number: 23511 Registered: 10-2007 Posted From: 174.37.61.78 Rating: N/A |
Mav, same type lo trying..but tantondi. nee deggara ex unte itu padei | ||
| Maverick Legend Username: Maverick Post Number: 32128 Registered: 01-2008 Posted From: 204.86.209.200 Rating: N/A |
date,time concat chesi query rai Who is this DB member? | ||
| Just4fun Megastar Username: Just4fun Post Number: 23510 Registered: 10-2007 Posted From: 174.37.61.78 Rating: N/A |
db oracle guys, input: Date (ex: 11/15/2011 08:00:00 AM) above input date use sesukoni, AAA table nunchi enteredate(11/15/2011), enteredtime (6:00AM) nunchi enterdate(11/16/2011), enteredtime(6:00 AM) between unna all records seelct cheyali select statement rayandi experts evaranna. table name: AAA columns: entereddate, enteredtime |
