KillerSites.com Web Design Forums - Change the date format Mysql - php

Re: Change the date format Mysql - php

dummy@example.com (edoplaza) — Thu, 05 Nov 2009 13:16:21 +0000

Finally, I found a solution:

I was trying to use the DATE_FORMAT function, but it didn't work (still don't know why)

I then changed this:

echo $row_RsEvents['column_date'];

Into this:

$formatted_date= $row_RsEvents['column_date'];
echo date("d-m-Y",strtotime($formatted_date));

and it works perfectly

Cheers,

Eduardo

Edit:

Sorry Wickham, I didn't see your last edit. I am glad we both came to the same solution! (but yours is better than mine )

Re: Change the date format Mysql - php

dummy@example.com (edoplaza) — Mon, 02 Nov 2009 00:26:48 +0000

Hi Wickham,

Thanks for your response. I haven't had the time to work today, but tomorrow I'll try what you suggest. I'll write a very simple code with just one record to isolate the problem and test different approaches. Also I bought a book with lots of information. I'm sure this is a common issue, it shouldn't be that hard.

Edited:

Ok, I uploaded a very simple page with one record:

http://www.germanmarcano.com/datetest.php

Code:






Untitled Document

I will try to work on this file and see what happens

Regards,

Eduardo

Re: Change the date format Mysql - php

dummy@example.com (Wickham) — Sun, 01 Nov 2009 07:13:38 +0000

EDIT - go to my edit at the bottom of the post.

No one else has answered so I will offer a little more information, but my PHP and MySQL knowledge is not much; I was hoping falkencreative would answer the question properly.

Your page display has this code
Date:

which just repeats what is in the database field 'fecha', so perhaps one solution is to change the format in the database, not in the PHP code which displays it on the page.

If you look at this example:-
http://www.wickham43.net/formphptomysql.php

You will see a form for submission of data which has a date already inserted with a date format and the database stores this as text (Field: Date; Type: text) and the display of the data in the table at the bottom of the page just shows the text of the date that the database stored. You can see from the dates in the display that the format changes half way down because I changed the date format in the top submission form.

My Date is stored as text but you probably have the database storing date in a date format. You don't show how you get the dates into the database; either change the date format in the form you use to input into the database or go into the database and change the date format there. MySQL date is always stored in the YYYY-MM-DD format and it's complicated to reformat it so it may be easier to change the database Type to Text and then the PHP for the page should output the same text as the database.

Editing the Type for the Field in MySQL is relatively simple and you would then have to edit the previous database entries manually but future date entries as text would be repeated as text by the PHP code.

I expect that there is a way to take the date format from the database and change it to another format with PHP for the table display but falkencreative will have to answer that.

EDIT: I've been experimenting and this code worked for me:-

date('d-m-Y', strtotime($row['fecha'])) but I was testing with a different database and a different form

so where you have

in your PHP file I think you need

Try it.

Re: Change the date format Mysql - php

dummy@example.com (Wickham) — Sat, 31 Oct 2009 21:34:38 +0000

All the date codes are here:-
http://php.net/manual/en/function.date.php

Use d-m-Y for dd-mm-yyyy

Change the date format Mysql - php

dummy@example.com (edoplaza) — Sat, 31 Oct 2009 19:32:30 +0000

Hello,

I'd like to change the date format from my DB (yyyy-mm-dd) to dd-mm-yyyy using php.

Here is the url:

http://ww w.germanmarcano.com/eventos/indexEnglish.php

Here is the code:















Events








    
         
        
        
            
            Home
          Biography
         Critics
        
        
            
            
            Repertory
          CDs
          Live Recordings
        
        
        
            
            
            Videos
             Publications
          Gallery
          
         
        
        
         
            
            
       
          Events
          Contact
          
         
        
      
    



  
   
   Events
   
   
     
       
       
       
        
         
      
          
        
                   
                     
                     
                     
                   
                     Date:
                        
                        
                   
                     Place:
                        
                        
                   
                     Time:
                        
                        
                 
                 
     
     



    
    
    home | administration |  contact    Copyright © Germán Marcano 2009

Thanks

Eduardo