47 users online (1 members and 46 guests)  


  Results 1 to 2 of 2

Related

  1. SQL Time Conversion    Forum: Databases
    Replies: 1
  2. PHP Time Display    Forum: PHP Forum
    Replies: 2
  3. down time    Forum: One Stop Domains Forum
    Replies: 1
  4. Third time lucky    Forum: HTML Forum
    Replies: 1
  1. #1
    gen23's Avatar
    New User

    Status
    Offline
    Join Date
    Jun 2005
    Posts
    1

    help with time and max()

    Hi,

    How can I display those records that have a timestamp that is lower than the maximum timestamp expecially if my mysql is version 3 only?
    For example: if today is 20050619175932, then the record that has this timestamp will not be displayed, and only the record with 200506191732 will be.

    Thanks!

  2. #2
    ovidiu's Avatar
    Disabled

    Status
    Offline
    Join Date
    Nov 2004
    Posts
    1

    Re: help with time and max()

    Hi,

    Try converting your timestamp with date(). Example:

    you have your time 200.... in $x

    $y = date("Y-m-d",$x);

    Then you can compare.

    I hope it works

    Claudiu



Tags for this Thread