Snipplr - jpkunst http://snipplr.com/users/jpkunst Recent snippets posted on Snipplr.com en-us Thu, 23 May 2013 11:50:57 GMT (MySQL) Convert textual dates of the form '[d]d-[m]m-yyyy' to actual dates http://snipplr.com/view/61680/convert-textual-dates-of-the-form-ddmmyyyy-to-actual-dates/ Converts textual dates like '1-3-1954' and '01-02-1963' to respectively '1954-3-1' and '1963-02-01'. MySQL is smart enough to understand the values without leading zeros when inserting into a DATE field.

]]> Tue, 06 Dec 2011 00:55:18 GMT http://snipplr.com/view/61680/convert-textual-dates-of-the-form-ddmmyyyy-to-actual-dates/ (MySQL) Select the first word in a text field http://snipplr.com/view/28916/select-the-first-word-in-a-text-field/

]]> Thu, 25 Feb 2010 11:31:09 GMT http://snipplr.com/view/28916/select-the-first-word-in-a-text-field/