Hello all,
I have a query that for some reason is now returning the incorrect year. First here is
my server configuration.
Windows 2003 Advanced server
MySQL version 4.0.15-nt
Here is my SQL statement:
SELECT
DATE_FORMAT(E.DateTime, '%X-%m-%d %h:%i:%s %p' ) AS DateTime,
E.SendCount AS SendCount,
E.TransactionStatus AS TransactionStatus,
E.Message AS Message,
TS.StatusDescription AS StatusDescription,
TS.ErrorWarningInd AS ErrorWarningInd
FROM errlog As E
LEFT JOIN TransStatusTable AS TS
ON E.TransactionStatus=TS.TransStatusCode
WHERE AccountName='INSTILL000'
AND Filename='SYSCO076_20040103125040.850'
AND AccountScheduleDetailID=331
ORDER BY SendCount, DateTime, TransactionStatus
The first column returned is the date. The values returned are such as '2003-01-03
02:50:16 PM'
If I replace the DATE_FORMAT() call 'DATE_FORMAT(E.DateTime, '%X-%m-%d %h:%i:%s %p' )
AS DateTime' with a simple 'E.DateTime AS DateTime'. the returned value is now correct
but the format is not.
I have run this SQL statement from the mysql command line interface. I did initially
use phpMyAdmin to see this. I just wanted to make sure this was not a PHP issue.
Any thoughts?
Paul
