having trouble getting a time to format and display properly ... here is my query:
SELECT
oID,
oFirstName,
oLastName,
oCompany,
oAddress1,
oAddress2,
oCity,
oState,
oZip,
oCountry,
oPhone,
oEmailAddress,
oCardType,
oCCNumber,
oExpMonth,
oExpYear,
oSecCode,
FROM_UNIXTIME(`orders`.`oDate`,'%Y-%m-%d') AS `Date`,
oStatus,
o_ship_FirstName,
o_ship_LastName,
o_ship_Company,
o_ship_Address1,
o_ship_Address2,
o_ship_City,
o_ship_State,
o_ship_Country,
o_ship_Zip,
oSessionID,
oIPAddress,
oQuantity,
oCustom,
oSource,
oEdition,
o_each_price
FROM orders
ORDER BY oID DESC
and i have the 'Date' field formatted in PHPR as short date
however, the fields keep displaying like:
1187375820
help?
karen