How to calculate the last Thursday of previous month from current month in MySQL? -

-

i have 1 problem. have 1 table contains columns id, price , date. every day, entry made in table, if there holiday no entry made. need calculate price on last thursday of previous month date in current month. if day holiday, should iterate next day , find close price day.

id  price    date 145 120   01-05-2013 (dd-mm-yyyy) 145 130   02-05-2013 145 140   03-05-2013 145 150   04-05-2013 145 154   06-05-2013 145 125   30-05-2013 145 124   31-05-2013 145 1236  01-06-2013 145 415   02-06-2013 145 124   03-06-2013 145 124   04-06-2013 145 122   05-06-2013 145 124   06-06-2013 145 125   29-06-2013 145 458   30-06-2013

i've tried:

select case weekday(last_day(curdate()-interval 1 month))  when 6 date_sub(last_day(curdate()-interval 1 month),interval 3 day) when 5 date_sub(last_day(curdate()-interval 1 month),interval 2 day) when 4 date_sub(last_day(curdate()-interval 1 month),interval 1 day) when 3 date_sub(last_day(curdate()-interval 1 month),interval 0 day) when 2 date_sub(last_day(curdate()-interval 1 month),interval 4 day) when 1 date_sub(last_day(curdate()-interval 1 month),interval 5 day) when 0 date_sub(last_day(curdate()-interval 1 month),interval 6 day) end day

(this query gives me last thursday of previous month. there possibility there holiday , table not contain date , price. should iterate in such way finds next entry.) there may more 1 holiday (christmas day, boxing day in countries celebrate both, example).


Comments

Post a Comment

Popular posts from this blog

html5 - What is breaking my page when printing? -

-
Image
i have questioner , don't know why when printing it's creating break before first question. live demo (link) i able resolve issue removing fieldset container had wrapped in.. having fieldset element causing of fields grouped together, , since not fit on first page, being pushed second page. removing fieldset element, able firefox print first 2 questions on page 1 identically chrome. it seems not new problem firefox , fieldset not playing nice found old bugzilla ticket 2008 has persisted , still being commented on in 2014 (link) if retaining fieldset important, found solution else came here (link) <script type='text/javascript'> $(window).bind('beforeprint', function(){ $('fieldset').each( function(item) { $(this).replacewith($('<div class="fieldset">' + this.innerhtml + '</div>')); } ) }); $(window).bind(
Read more

c# - must be a non-abstract type with a public parameterless constructor in redis -

-
when save object, got below error must non-abstract type public parameterless constructor in order use parameter 't' in generic type or method 'servicestack.redis.redisclient.store<t>(t) redisclass.getinstnace().store(msg); // error here redisclass.getinstnace().save(); as third party's class, can not edit how save object? could create wrapper around third party object call constructor, store wrapper? e.g. public class mywrapper { public thirdpartyobject thirdpartyinstance { get; set; } public mywrapper() { thirdpartyinstance = new thirdpartyobject("constructors"); } }
Read more

ajax - PHP/JSON Login script (Twitter style) not setting sessions -

-
i'm having trouble getting twitter style login work properly, reason gets stuck at session_register("useremail"); session_register("userpass"); and doesn't redirect after it. if enter wrong account data, works , appropriate error message pops up. this full code: <?php if(empty($_post['email']) || empty($_post['password'])) { die(msg(0,"all fields required")); } if(!(preg_match("/^[\.a-z0-9_\-\+]+[@][a-z0-9_\-]+([.][a-z0-9_\-]+)+[a-z]{1,4}$/", $_post['email']))) die(msg(0,"you haven't provided valid e-mail")); $host="localhost"; $username="root"; $password="x"; $db_name="x"; $tbl_name="x"; mysql_connect("$host", "$username", "$password")or die("cannot connect"); mysql_select_db("$db_name")or die("cannot select db"); $useremail=$_post['email']; $userpass=
Read more