Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 4 of 4
  1. #1
    Regular Coder
    Join Date
    Jan 2004
    Location
    Des Moines, Iowa
    Posts
    219
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Wrong Time Formats in MySQL database

    I'm posting this in this forum and the MySQL forum...

    Here is the scenario...

    I have a table that has two columns departure, arrive... They are VARCHAR fields and so not stored with any timestamp or anything, just plain old strings.

    Anywho... SOME of the values are in AM/PM format... like... 9:30AM or 9:30PM. SOME of the values are in 24-Hour format...

    I NEED to get everything into 24-Hour format - and have 11,000 records to process... Don't want to do each one manually <G>.

    I need the items that are like 9:30AM to end up as 09:30 and those like 9:30PM to be 21:30..

    I'm racking my brain to come up with a PHP script and I think I'm giving up until someone sparks me with a hint. :-)~

    Thanks,
    ~Rich
    Rich S. Wyatt
    D3 Web Creations

  • #2
    raf
    raf is offline
    Master Coder
    Join Date
    Jul 2002
    Posts
    6,589
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Where would you like me to answer your question? --> remove one of your threads, preferably the mySQL one
    Posting guidelines I use to see if I will spend time to answer your question : http://www.catb.org/~esr/faqs/smart-questions.html

  • #3
    Regular Coder
    Join Date
    Jan 2004
    Location
    Des Moines, Iowa
    Posts
    219
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I was hoping that there was either a mysql answer or a PHP answer or one of each. I like variety.
    Rich S. Wyatt
    D3 Web Creations

  • #4
    Supreme Overlord Spookster's Avatar
    Join Date
    May 2002
    Location
    Marion, IA USA
    Posts
    6,278
    Thanks
    4
    Thanked 83 Times in 82 Posts
    Since you don't like to abide by our rules and guidelines I am closing this thread.

    Don't crosspost!

    Change values in MySQL database

    Closing thread...
    Spookster
    CodingForums Supreme Overlord
    All Hail Spookster


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •