MySQL Lists are EOL. Please join:

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:
>and this for ways to work with date and time information:
>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
String FormattingDaniel Kasak19 Dec
  • Re: String FormattingSGreen19 Dec
    • Re: String FormattingDaniel Kasak19 Dec