current_date casting

Posted by Armen Mkrtchyan on Stack Overflow See other posts from Stack Overflow or by Armen Mkrtchyan
Published on 2010-04-16T07:49:26Z Indexed on 2010/04/16 7:53 UTC
Read the original article Hit count: 302

Filed under:
|

Hi.

string selectSql = "update " + table + " set state_" + mode + "_id=1 WHERE stoping_" + mode + " < current_date;";

when i call current_date, it return yyyy-MM-dd format, but i want to return dd.MM.yyyy format, how can i do that. please help. my program works fine when i am trying

string selectSql = "update " + table + " set state_" + mode + "_id=1 WHERE stoping_" + mode + " < '16.04.2010';";

© Stack Overflow or respective owner

Related posts about mysql

Related posts about datetime