Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

Pretty Basic Problem

anthonyqkiernaanthonyqkierna Member Posts: 3
I have a timestamp as one of the fields in my database table. I want to select everything that has a timestamp withing the last thirty days. how do I do it? I realise this is probably very easy, but it's driving me mad.

Comments

  • JonathanJonathan Member Posts: 2,914
    : I have a timestamp as one of the fields in my database table. I
    : want to select everything that has a timestamp withing the last
    : thirty days. how do I do it? I realise this is probably very easy,
    : but it's driving me mad.

    WHERE timestampfield > NOW() - INTERVAL 30 DAYS

    I think! ;-)

    Jonathan


    ###
    for(74,117,115,116){$::a.=chr};(($_.='qwertyui')&&
    (tr/yuiqwert/her anot/))for($::b);for($::c){$_.=$^X;
    /(p.{2}l)/;$_=$1}$::b=~/(..)$/;print("$::a$::b $::c hack$1.");

Sign In or Register to comment.