mysql has STR_TO_DATE function, check out http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html#function_str-to-date, then use UNIX_TIMESTAMP(),
select SELECT UNIX_TIMESTAMP( STR_TO_DATE(dateStr, '%m/%d/%Y')) as myDate order by myDate. regards On Oct 8, 2:35 pm, "Karl" <[EMAIL PROTECTED]> wrote: > Thanks Anru... an interesting sounding solution... > > How does one go about translating strings within an SQL statement > please? (Unashamed QueryN00b) > > Cheers... > > *********** REPLY SEPARATOR *********** > > On 7/10/2008 at 6:09 p.m. ctx2002 wrote: > > >translate dd-mm-yy to unixtime stamp, then order by that unixtime > >stamp. you can do it within one SQL statement. > > --- > Karl > Senior Account Managerwww.KIWIreviews.co.nz... Where Your Views Count > Please consider the environment before printing this email. > > Supporting Palmerston North's Santa... see our Community Gold Project > page:http://www.KIWIreviews.co.nz/santa- To be seen on TVNZ's 'Mucking In' > show! --~--~---------~--~----~------------~-------~--~----~ NZ PHP Users Group: http://groups.google.com/group/nzphpug To post, send email to [email protected] To unsubscribe, send email to [EMAIL PROTECTED] -~----------~----~----~----~------~----~------~--~---
