User Profile

Collapse

Profile Sidebar

Collapse
natpres
natpres
Last Activity: Feb 11 '10, 05:05 PM
Joined: Feb 11 '10
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • natpres
    replied to Date_Format issues.
    in MySQL
    Works 100%

    Thank you for your reply. Amazing how simple something is when someone else points something out!

    Cheers
    See more | Go to post

      Leave a comment:

    • natpres
      started a topic Date_Format issues.
      in MySQL

      Date_Format issues.

      I am having issues with a MySql query

      Code:
      SELECT *,DATE_FORMAT(startdate, '%d-%m-%Y')AS startdate, startdate as sortdate 
from {$table} 
WHERE DATE_FORMAT(startdate, '%d-%m-%Y') >= DATE_FORMAT(now(), '%d-%m-%Y') 
ORDER BY sortdate ASC
      It will not show any dates in the future is the day is less then the current day.

      For example it will show the entry with a date of 2010-05-20
      ...
      See more | Go to post
      Last edited by Atli; Feb 11 '10, 04:49 PM. Reason: Added [code] tags and added a couple of linebreaks to the query.
      No activity results to display
      Show More
      Working...