MYSQL select date format query

MYSQL select date format query

04-20-2009, 08:48 AM

[eluser]Armchair Samurai[/eluser]
You need an alias in your SQL

Code:
$sql = "SELECT news, DATE_FORMAT(date, ‘%d%m%y’) AS date

        FROM news";

Messages In This Thread

MYSQL select date format query - by El Forum - 04-20-2009, 08:06 AM

MYSQL select date format query - by El Forum - 04-20-2009, 08:12 AM

MYSQL select date format query - by El Forum - 04-20-2009, 08:16 AM

MYSQL select date format query - by El Forum - 04-20-2009, 08:20 AM

MYSQL select date format query - by El Forum - 04-20-2009, 08:29 AM

MYSQL select date format query - by El Forum - 04-20-2009, 08:48 AM

MYSQL select date format query - by El Forum - 04-20-2009, 08:50 AM