php - Unable to get "inbetween" records if year is different -

-

i having unique bug

table : tbl id | title | iscancel | sold_dt  id: uid title : varchar iscancel : 0/1 sold_dt : timestamp   select * tbl iscancel = 0 , date_format(sold_dt,"%m/%d/%y") between "06/01/2015" , "03/01/2016" group day(sold_dt) order (sold_dt) asc

(note year different)

  • 0 records returned

but if do

select * tbl iscancel = 0 , date_format(sold_dt,"%m/%d/%y") between "06/01/2015" , "12/01/2015" group day(sold_dt) order (sold_dt) asc

or 

select * tbl iscancel = 0 , date_format(sold_dt,"%m/%d/%y") between "01/01/2016" , "03/01/2016" group day(sold_dt) order (sold_dt) asc

(note year same)

-i'll records

*used date_format because calendar giving me mm/dd/yyyy (i can not change since might affect other areas)

what doing wrong?

instead of converting stored value format try changing parameter correct format. if cant on website can in query well

sold_dt between str_to_date('06/01/2015', '%m/%d/%y') , str_to_date('03/01/2016', '%m/%d/%y')

Comments

Post a Comment

Popular posts from this blog

mongodb - Struggling to get ordered results from the last retrieved article, given array of elements to search in -

-
i have collections of objects structure this: { "_id" : objectid("5233a700bc7b9f31580a9de0"), "id" : "3df7ce4cc2586c37607a8266093617da", "published_at" : isodate("2013-09-13t23:59:59z"), ... "topic_id" : [ 284, 9741 ], ... "date" : numberlong("1379116800055") } i'm trying use following query: db.collection.find({"topic_id": { $in: [ 9723, 9953, 9558, 9982, 9833, 301, ... 9356, 9990, 9497, 9724] }, "date": { $gte: 1378944001000, $lte: 1378954799000 }, "_id": { $gt: objectid('523104ddbc7b9f023700193c') }}).sort({ "_id": 1 }).limit(1000) the above query uses topic_id, date index not keep order of returned results. forcing use hint({_id:1}) makes results ordered, nscanned 1 million documents though limit(1000) specified. what missing?
Read more

c# - Pausing a storyboard on TabItem mouse over -

-
i have tab control invisible tabs. when mouse on area of form, calls c# handler runs: ((storyboard)findresource("animate")).begin(hiddentab); the animate storyboard: <storyboard x:key="animate"> <objectanimationusingkeyframes begintime="0:0:0" storyboard.targetproperty="visibility"> <discreteobjectkeyframe keytime="0"> <discreteobjectkeyframe.value> <visibility>visible</visibility> </discreteobjectkeyframe.value> </discreteobjectkeyframe> </objectanimationusingkeyframes> <doubleanimation begintime="0:0:0.0" storyboard.targetproperty="opacity" from="0" to="1" duration="0:0:0.2"/> <doubleanimation begintime="0:0:2.5" storyboard.targetproperty="opacity" from="1" to="0...
Read more

c# - Attribute value in root node of xml Linq to XML -

-
while parsing xml linq xml, came across strange behaviour (atleast me). below first xml parsed `<?xml version="1.0" encoding="utf-8"?> <testrun> <unittestresult testname = "arun" outcome = "i"> </unittestresult> <unittestresult testname = "arun1" outcome = "i"> </unittestresult> </testrun>` my code looks xdocument doc = xdocument.parse(filecontents); var result = doc.descendants("unittestresult"); the above works fine. if root node contain attributes same code not working. reason. xml sample below <?xml version="1.0" encoding="utf-8"?> <testrun id="7903b4ff-8706-4379-b9e8-567034b70abb" name="inaambika@inbelw013312a 2016-02-26 16:55:14" runuser="stc\inaambika" xmlns="http://microsoft.com/schemas/visualstudio/teamtest/2010"> <unittestresult testname = "arun" outcome = "...
Read more