Professional Web Applications Themes

Frail loop - MySQL

I'm finally trying to get to grips with mysql's date functions. How might I construct a simple query that would show me the result of a statement like the following? FROM_DAYS(TO_DAYS('2007-03-31')+1) Any help greatly appreciated - and, ideally, before noon (GMT) today....

  1. #1

    Default Frail loop

    I'm finally trying to get to grips with mysql's date functions. How
    might I
    construct a simple query that would show me the result of a statement
    like the following?

    FROM_DAYS(TO_DAYS('2007-03-31')+1)

    Any help greatly appreciated - and, ideally, before noon (GMT) today.

    strawberry Guest

  2. #2

    Default Re: Frail loop

    On 31 Mar 2007 16:16:29 -0700, strawberry wrote: 

    You mean like

    mysql> select FROM_DAYS(TO_DAYS('2007-03-31')+1) newdate;
    +------------+
    | newdate |
    +------------+
    | 2007-04-01 |
    +------------+
    1 row in set (0.00 sec)

    ?


    --
    59. I will never build a sentient computer smarter than I am.
    --Peter Anspach's list of things to do as an Evil Overlord
    Peter Guest

  3. #3

    Default Re: Frail loop

    On Apr 1, 12:55 am, "Peter H. Coffin" <com> wrote: 


    >
    > You mean like
    >
    > mysql> select FROM_DAYS(TO_DAYS('2007-03-31')+1) newdate;
    > +------------+
    > | newdate |
    > +------------+
    > | 2007-04-01 |
    > +------------+
    > 1 row in set (0.00 sec)
    >
    > ?
    >
    > --
    > 59. I will never build a sentient computer smarter than I am.
    > --Peter Anspach's list of things to do as an Evil Overlord[/ref]

    :-)

    2007-04-01

    Frail loop - April Fool!

    strawberry Guest

  4. #4

    Default Re: Frail loop

    strawberry wrote: 

    ROFLMAO!

    --
    ==================
    Remove the "x" from my email address
    Jerry Stuckle
    JDS Computer Training Corp.
    net
    ==================
    Jerry Guest

  5. #5

    Default Re: Frail loop

    On Apr 1, 3:07 am, Jerry Stuckle <net> wrote: 


    >
    > ROFLMAO!
    >
    > --
    > ==================
    > Remove the "x" from my email address
    > Jerry Stuckle
    > JDS Computer Training Corp.
    > net
    > ==================[/ref]

    :-) I notice Peter's gone very quiet...

    strawberry Guest

  6. #6

    Default Re: Frail loop

    On 1 Apr 2007 06:50:29 -0700, strawberry wrote: 
    >> 
    >> 
    >>
    >> ROFLMAO!
    >>[/ref]
    >:-) I notice Peter's gone very quiet...[/ref]

    I claim foul on the grounds that your posting was on March 31 by your
    machine's clock:

    ---------------------
    On 31 Mar 2007 16:16:29 -0700, strawberry wrote: 
    ---------------------

    You can't even push it off to GMT from there... And we've have more
    obviously "haven't tried" questions than that.

    --
    56. My Legions of Terror will be trained in basic marksmanship. Any who
    cannot learn to hit a man-sized target at 10 meters will be used for
    target practice.
    --Peter Anspach's list of things to do as an Evil Overlord
    Peter Guest

  7. #7

    Default Re: Frail loop

    On Apr 1, 5:28 pm, "Peter H. Coffin" <com> wrote: [/ref]
    > [/ref]
    > [/ref]
    > [/ref]

    >
    > I claim foul on the grounds that your posting was on March 31 by your
    > machine's clock:
    >
    > ---------------------
    > On 31 Mar 2007 16:16:29 -0700, strawberry wrote:> I'm finally trying to get to grips with mysql's date functions. How 
    >
    > ---------------------
    >
    > You can't even push it off to GMT from there... And we've have more
    > obviously "haven't tried" questions than that.
    >
    > --
    > 56. My Legions of Terror will be trained in basic marksmanship. Any who
    > cannot learn to hit a man-sized target at 10 meters will be used for
    > target practice.
    > --Peter Anspach's list of things to do as an Evil Overlord[/ref]

    That's YOUR machine's clock. I posted at 12:16 am on April 1st fair
    and square.
    (I can do a screen dump to prove it)
    Anyway - the message subject and the answer should have been a clue -
    as well as the sheer blinding stupidity of the question itself!!!

    Anyway, enjoy the rest of your weekend.

    ;-)

    strawberry Guest

Similar Threads

  1. Loop option set, but flash doesn't loop
    By uj666 in forum Macromedia Flash Player
    Replies: 6
    Last Post: October 21st, 04:23 AM
  2. loop list and compare to query loop
    By boxhead in forum Coldfusion - Advanced Techniques
    Replies: 4
    Last Post: September 9th, 08:38 AM
  3. Film loop rollovers working with tell sprite, but only if Loop is checked
    By Schiemer webforumsuser@macromedia.com in forum Macromedia Director Basics
    Replies: 0
    Last Post: November 27th, 06:02 AM
  4. Urgent: Repeat loop and Film loop clash!
    By Jai G in forum Macromedia Director Lingo
    Replies: 4
    Last Post: July 31st, 04:39 AM
  5. Help with loop inside loop and mysql queries
    By Petre Agenbag in forum PHP Development
    Replies: 1
    Last Post: July 16th, 07:36 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139