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
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