logo
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Options
Go to last post Go to first unread
irreddy123  
#1 Posted : Friday, December 02, 2016 6:10:35 AM(UTC)
irreddy123

Rank: Member

Groups: Registered
Joined: 10/31/2016(UTC)
Posts: 13
India
Location: hyd

Dear Admin
I am trying to use my sql between dates but its not working fine most of the times its showing wrong data and blank
so kindly help me for the same

Thanks
epf  
#2 Posted : Friday, December 02, 2016 8:23:13 AM(UTC)
epf

Rank: Administration

Groups: Administrators
Joined: 12/20/2013(UTC)
Posts: 384
Switzerland

Thanks: 6 times
Was thanked: 51 time(s) in 50 post(s)
Are you using the 3.0 version ?
Did you check the date format specified in your connection (normally "yyyy-MM-dd HH:mm:ss" for standard database), the default should work fine for a default sql installation...
I made a quick try with the demo db:

Code:
SELECT DISTINCT
  film.title AS C0,
  film.description AS C1,
  film.release_year AS C2,
  film.last_update AS C3
FROM film
WHERE (film.last_update Between '2006-02-15 05:03:42' AND '2006-02-15 05:04:00')
ORDER BY film.title ASC,film.description ASC,film.release_year ASC,film.last_update ASC


the sql is correct.

irreddy123  
#3 Posted : Friday, December 02, 2016 12:04:04 PM(UTC)
irreddy123

Rank: Member

Groups: Registered
Joined: 10/31/2016(UTC)
Posts: 13
India
Location: hyd

Yes Currently i am using 3.0 version
and date format is default ("yyyy-MM-dd HH:mm:ss")
when i select between two dates it's showing blank and total number of records 2 lakhs +
kindly suggest me solution for this

Tool is very very good
epf  
#4 Posted : Friday, December 02, 2016 1:10:39 PM(UTC)
epf

Rank: Administration

Groups: Administrators
Joined: 12/20/2013(UTC)
Posts: 384
Switzerland

Thanks: 6 times
Was thanked: 51 time(s) in 50 post(s)
can you post the SQL generated...
irreddy123  
#5 Posted : Tuesday, December 06, 2016 6:48:56 AM(UTC)
irreddy123

Rank: Member

Groups: Registered
Joined: 10/31/2016(UTC)
Posts: 13
India
Location: hyd

Thanks its working fine the problem with bad joins
Users browsing this topic
Guest (3)
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Powered by YAF 2.0.0 | YAF © 2003-2017, Yet Another Forum.NET
This page was generated in 0.069 seconds.