• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Problem in paging nation with date format

 
Rd Dari
Ranch Hand
Posts: 212
Java Netbeans IDE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi all Ranchers,

I am facing a problem in where clause like this:
select invoiceNo from invoice where current_date_time between STR_TO_DATE('14-03-2012','%d-%m-%Y') and STR_TO_DATE('14-03-2012','%d-%m-%Y')

AND
select invoiceNo from invoice where current_date_time between '2012-03-14 00:00:00' and '2012-03-14 23:59:59'


these are working properly but in pagingnation these working for sometimes after some time these creating a problem

here is my code you can check out it:



when i use pagingnation then dateFrom and dateTo spliling once again so problem are;;;;;;

suggest me!

Thanks in advanced!!

 
Wendy Gibbons
Bartender
Posts: 1111
Eclipse IDE Oracle VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Sorry, but i have no idea what your prblem is, what is actually going wrong? what has pagination got to do with anything? what effect is it having?
if you are getting an exception can you copy and paste that in.
 
Rd Dari
Ranch Hand
Posts: 212
Java Netbeans IDE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

thanks for reply but the problem has been resolved........

Thanks
 
Rob Spoor
Sheriff
Pie
Posts: 20559
57
Chrome Eclipse IDE Java Windows
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Would you like to share how, so others can learn from it?
 
Rd Dari
Ranch Hand
Posts: 212
Java Netbeans IDE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi all,



Actually I was using STR_TODATE('"+dateFrom+"','%d-%m-%Y') and STR_TO_DATE('"+dateTo+"','%d-%m-%Y') rather than current_date_time between '"+dateFrom+" 00:00:00' and '"+dateTo+" 23:59:59'

the problem with str_to_date that searching for current date was not running in a proper way but to select last date(last date) its was running successfully....

Thanks
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic