| Author |
Message |
   
Padmasri
Junior Artist Username: Padmasri
Post Number: 685 Registered: 10-2011 Posted From: 72.101.222.22
Rating: N/A Votes: 0 (Vote!) | | Posted on Tuesday, November 15, 2011 - 06:27 pm: |
    |
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 Votes: 0 (Vote!) | | Posted on Tuesday, November 15, 2011 - 06:24 pm: |
    |
Sachin:j4f asalu em sadhinchali anukunnav nuvvu
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 Votes: 0 (Vote!) | | Posted on Tuesday, November 15, 2011 - 06:13 pm: |
    |
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 Votes: 0 (Vote!) | | Posted on Tuesday, November 15, 2011 - 05:45 pm: |
    |
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 Votes: 0 (Vote!) | | Posted on Tuesday, November 15, 2011 - 05:41 pm: |
    |
Thank you all guys.
Simpletruth:Entered time vunna chota date petti emiti. Akkada column name undali.
ikkade tantondi..solved spl thx bro  |
   
Twitter
Hero Username: Twitter
Post Number: 13110 Registered: 10-2009 Posted From: 151.191.175.206
Rating: N/A Votes: 0 (Vote!) | | Posted on Tuesday, November 15, 2011 - 05:32 pm: |
    |
Just4fun:entereddate - date
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 Votes: 0 (Vote!) | | Posted on Tuesday, November 15, 2011 - 05:30 pm: |
    |
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 Votes: 0 (Vote!) | | Posted on Tuesday, November 15, 2011 - 05:29 pm: |
    |
Just4fun:
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) |
   
Twitter
Hero Username: Twitter
Post Number: 13109 Registered: 10-2009 Posted From: 151.191.175.206
Rating: N/A Votes: 0 (Vote!) | | Posted on Tuesday, November 15, 2011 - 05:27 pm: |
    |
Just4fun:HH12:MI:SS AM
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 Votes: 0 (Vote!) | | Posted on Tuesday, November 15, 2011 - 05:26 pm: |
    |
Twitter: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')
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 .. |
   
Twitter
Hero Username: Twitter
Post Number: 13107 Registered: 10-2009 Posted From: 151.191.175.206
Rating: N/A Votes: 0 (Vote!) | | Posted on Tuesday, November 15, 2011 - 05:21 pm: |
    |
Just4fun:
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 Votes: 0 (Vote!) | | Posted on Tuesday, November 15, 2011 - 05:19 pm: |
    |
Simpletruth:To date ( To char(entereddate) + ' ' + to char (entered time)) Between start date and end date
Just4fun: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')
ade kada babai nenu rasindi..invalid number ani error vastondi |
   
Twitter
Hero Username: Twitter
Post Number: 13106 Registered: 10-2009 Posted From: 151.191.175.206
Rating: N/A Votes: 0 (Vote!) | | Posted on Tuesday, November 15, 2011 - 05:18 pm: |
    |
Just4fun:
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 Votes: 0 (Vote!) | | Posted on Tuesday, November 15, 2011 - 05:16 pm: |
    |
Just4fun:
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 Votes: 0 (Vote!) | | Posted on Tuesday, November 15, 2011 - 05:13 pm: |
    |
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 Votes: 0 (Vote!) | | Posted on Tuesday, November 15, 2011 - 05:09 pm: |
    |
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 Votes: 0 (Vote!) | | Posted on Tuesday, November 15, 2011 - 05:05 pm: |
    |
Maverick:date,time concat chesi query rai
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 Votes: 0 (Vote!) | | Posted on Tuesday, November 15, 2011 - 05:02 pm: |
    |
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 Votes: 0 (Vote!) | | Posted on Tuesday, November 15, 2011 - 04:59 pm: |
    |
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 |