[RESOLVED] SQL Date_Format

[dcjones]

Hi all.

I am having a problem with formatting dates in my query. This is what I have

SELECT *,  DATE_FORMAT(accomarival '%Y/%m/%d') as date1, DATE_FORMAT(accomdepart '%Y/%m/%d') as date2
FROM table1
WHERE member_id = colname OR secure_id_1 = colname1  OR secure_id_2 = colname2  OR  secure_id_3 = colname3  OR  secure_id_4 = colname4  OR  secure_id_5 = colname5  OR  secure_id_6 = colname6  OR  secure_id_7 = colname7  OR  secure_id_8 = colname8

Can anyone see what is wrong. please

[dcjones]

Hi all.

Solved

[Installer]

You are missing commas to separate the function arguments.