date formats and searching

[TheDigglerUK]

Hi,

How do convert the date 2012-02-16 into day format ike Wednesday 16th February, 2012 or something similar. Also when searching the database how do add to search from dates after a date like 2012-02-16

Thanks in advance

[bradgrafelman]

Which DBMS are you using? I'll assume MySQL...

TheDigglerUK;10996483 wrote:

How do convert the date 2012-02-16

DATE_FORMAT()

TheDigglerUK;10996483 wrote:

when searching the database how do add to search from dates after a date like 2012-02-16

WHERE date_col > '2012-02-16'

[Ashley_Sheridan]

In PHP you can do something like this:

echo date("l jS F,Y", strtotime($date_field_from_db));

The date manual is very useful for this.

Searching in a query against a date is like bradgrafelman mentioned. You can use mathematical operators on it and compare it to a date string (as long as it's in the right format yyyy-mm-dd) with things like =,< & >.

There are also times when you can treat the date like a string and use string operators on it in SQL, but that might be a bit beyond what you need right now.