Greetings. I've got some time data that is in an unfortunate format - stripped of colons and leading zeros, eg:
00:00:10 is simply: 10 and 00:02:00 is: 200 Nice, eh? Until today, I assumed that I had *seconds*, but apparently not ... Is there a formatting function that allows me to apply a formatting template, eg: string_format( my_string, 'dd:dd:dd ) d is 'digit' ... I'm clearly making this up as I go here. I've checked the online docs, and I've found 'format' but it only seems to be for numeric data. Any ideas? Or do I have to piece together a big combo statement with lots of if(), length(), locate() etc? -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http://www.nusconsulting.com.au -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
