将日期放入美国格式的临时表中

Question

好的，我的代码创建了一个临时表，包含一个日期字段，然后从几个表中获取数据写入临时表。

cruises表中的日期是一个日期时间字段，具有日、月、年和时间。

我想写的临时表只有日期，在美国格式…

    $maketemp = "CREATE TEMPORARY TABLE temp(`sailingId` int NOT NULL,
        `live` varchar(1), `ship` varchar(20), `code` varchar(5), `title` varchar(255), 
        `sailDate` date,`fromport` varchar(255), `nights` varchar(3), `type` varchar(30), 
        `fare` varchar(5), `offerFare` varchar(5),`deposit` varchar(5))"; 

mysql_query( $maketemp, $connection ) or die ( "Sql error : " . mysql_error ( ) );

$inserttemp = "INSERT INTO temp SELECT cruises.id AS sailingId, live, cruises.ship AS ship, 
        cruises.code AS code, cruises.title AS title, DATE_FORMAT(cruises.departs, '%m-%d-%y') AS sailDate,
        cruises.fromport AS fromport, cruises.duration AS nights, fares_usa.type AS type,
        fares_usa.fare AS fare, fares_usa.offered AS offerFare, supplements_usa.deposit AS 
        deposit FROM cruises, fares_usa, supplements_usa WHERE live ='Y' AND 
        cruises.id = fares_usa.cruise_id AND fares_usa.cruise_id = supplements_usa.cruise_id";

mysql_query( $inserttemp, $connection ) or die ( "Sql error : " . mysql_error ( ) );

当前显示为CSV时，日期字段要么是0000-00-00，要么是过去的错误日期，如13-Mar-2001

Rich :)

Answer 1

查看date_format文档或直接使用PHP格式化它。