Advanced Search

Return to Snippet

Revision: 30244
at August 10, 2010 17:21 by alexandrepayet
Initial Code 
SELECT DATE_FORMAT(date, '%d/%m/%Y à %H:%i:%S') AS datef FROM table;

#par defaut un champs datetime est au format US, a  savoir : aaaa-mm-jj hh:mm:ss
Initial URL 

                                

                                                            

                                    

                                        

                                        Initial Description
                                        

                                    

                                    

                                

                                                            

                                    

                                        

                                        Initial Title
                                        

                                    

                                    
MYSQL : changer le format d'un champs datetime dans un select

                                

                                                            

                                    

                                        

                                        Initial Tags
                                        

                                    

                                    
mysql, query

                                

                                                            

                                    

                                        

                                        Initial Language
                                        

                                    

                                    
MySQL