Terry , thank you .
The query worked on it's own, but within the PHP it
got thrown back. Alias worked well.
Sorry , sort of new to db / webdev.
Stuart
--- Terry Riley <[EMAIL PROTECTED]> wrote:
> Stuart, why not change your select statement
> (assuming it is correct and
> actually works, in a
Stuart, why not change your select statement (assuming it is correct and
actually works, in and of itself) to give the date-formatted field an
alias:
SELECT
LFWJobBank.JobReferenceCode,DATE_FORMAT(LFWJobBank.Entered,'%m/%d/%Y') AS
date_entered,
LFWJobBank.DazeLeft, LFWJobBank.JobTitle
FROM LFWJ
Is there something wrong with this code ?
Still confused after reading the manual.
Fields('DATE_FORMAT('LFWJobBank'.'Entered','%m/%d/%Y'));
?>
"Entered" is a "timestamp" column.
With the apostrophes off the table / column I get
errors about unexpected % .
Here is my SQL statement
SELECT
LFWJ
