Hello
I looking for a way to convert a datestring to date value example UnknowFunction('23.03.68','dd.mm.yy') -> unixtimestamp
In oracle we have to_date('23.03.68','dd.mm.yy')
I have search the net for hours without luck.
There will be a function for this in 4.1.1, called ... uh, STR_TO_DATE(), I think.
It'll return a DATETIME, not a TIMESTAMP, though. As has already been pointed out, your date cannot be a TIMESTAMP, which has a range beginning in 1970.
Regards Kim G. Pedersen macaos/elprint Development +45 35373808
-- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com
Are you MySQL certified? http://www.mysql.com/certification/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
