Can anyone tell me what the following query means?
I need to translate some of these ms sql tables to mysql.

Thanks
-------------

"SELECT SUN_DB,ACCNT_CODE, ACCNT_NAME, ANAL_A1, ANAL_A2, ANAL_A7, BAD_DEBTOR_FLAG, CONVERT(VARCHAR,DATE_FOR_ACTION,103) AS DATE_FOR_ACTION FROM SSRFACC WHERE ACCNT_CODE='" & strID & "'"

It looks likes a character string which will ultimately be executed as an SQL query which will SELECT several columns from the SSRFACC table, including a datetime column named DATE_FOR_ACTION. This column will be presented as a variable length character string with the datetime value converted to DD/MM/YYYY format. This converted character string column will be named DATE_FOR_ACTION in the resultset. The query will select the rows whose ACCNT_CODE is equal to the contents of the local variable (in the client code which is generating the query string) named 'strID' at the time the line generating this query string was executed in the client.

Jeff Mason
Custom Apps, Inc.
www.custom-apps.com

thanks a lot Jeff, it was a very detailed description. I shouldn't have pasted the entire query.. what I really wanted to ask is this part:

CONVERT(VARCHAR,DATE_FOR_ACTION,103) AS DATE_FOR_ACTION

from what u've explained, I can understand the effect of this line now, but how can I represent the same thing in mysql?

Thanks

Can't help you there - you might try asking in the 'mySQL' forum...

Jeff Mason
Custom Apps, Inc.
www.custom-apps.com

Hi:)

I think it may sorted out your issuess.

Sample Query In mySQL
SELECT DATE_FORMAT(date_column_name, '%Y/%m/%d') from table_name.