[rasinc]

Hi Peter,

Thanks for responding. I did just type in the syntax and used generic names. However, I have done several tests and the Right, Left and Replace functions allow a space before the parenthesis. Concat, Date_Format and Format do not allow a space for some reason. Now that I know, it works fine.

I should mention, I created the basic query using the Query Builder, so I was not typing the database, table or field names myself.

I'm just used to using spaces when I do Crystal Reports programming and need to remember when in SQLyog not to use them. I am getting the correct result set now.

[rasinc]

'rasinc' wrote:

Code:

SELECT
DATE_FORMAT (`tablename`.`dtDate`, '%Y%m%d') AS `CheckDate`
FROM
`database`.`tablename`
ORDER BY `CheckDate` ASC;

Proper code

Code:

SELECT
DATE_FORMAT(`tablename`.`dtDate`, '%Y%m%d') AS `CheckDate`
FROM
`database`.`tablename`
ORDER BY `CheckDate` ASC;

Sorry, never mind. I've got it now. Had no idea the space after DATE_FORMAT was critically bad! It's not an issue for LEFT and RIGHT functions.

[Author]

Posts