List:General Discussion« Previous MessageNext Message »
From:Daniel Kasak Date:December 18 2005 11:48pm
Subject:Re: String Formatting
View as plain text  
SGreen@stripped wrote:

>You may not be as bad off as you think you are.  One of the ways to write 
>datetime information in MySQL is yyyymmddhhMMss so if you left-padded with 
>zeroes each of your numbers to 14 total places, then inserted it into a 
>datetime field (or fed it to a function that took datetime information 
>like DATE_FORMAT()) it should be re-rendered into all of it's original 
>datetime componenents.
>
>Read this for details:
>http://dev.mysql.com/doc/refman/4.1/en/datetime.html
>and this for ways to work with date and time information:
>http://dev.mysql.com/doc/refman/4.1/en/date-and-time-functions.html
>
>Shawn Green
>Database Administrator
>Unimin Corporation - Spruce Pine
>  
>
Thanks :)

-- 
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: dkasak@stripped
website: http://www.nusconsulting.com.au
Thread
String FormattingDaniel Kasak19 Dec
  • Re: String FormattingSGreen19 Dec
    • Re: String FormattingDaniel Kasak19 Dec