Is there something wrong with this code ?
Still confused after reading the manual.
<td><?php echo
$rsJobShortDat->Fields('DATE_FORMAT('LFWJobBank'.'Entered','%m/%d/%Y'));
?></td>
"Entered" is a "timestamp" column.
With the apostrophes off the table / column I get
errors about unexpected % .
Here is my SQL statement
SELECT
LFWJobBank.JobReferenceCode,DATE_FORMAT(LFWJobBank.Entered,'%m/%d/%Y'),
LFWJobBank.DazeLeft, LFWJobBank.JobTitle
FROM LFWJobBank
WHERE VendorID = colname
Thank you,
Stuart
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
