Functions for converting dates to and from various formats include [man]date[/man], [man]strtotime[/man] and [man]mktime[/man] in PHP, and whatever functions your DBMS supplies for use in SQL queries.
A very general answer for a very general question.