Your Ad Here

advanced code snippet search

Posted By

alexandrepayet on 08/10/10


Tagged

mysql select query DateTime dateformat formater requetes


Versions (?)

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

 / Published in: MySQL
 
Expand | Embed | Plain Text 
  1. SELECT DATE_FORMAT(DATE, '%d/%m/%Y à %H:%i:%S') AS datef FROM table;
  2.  
  3. #par defaut un champs datetime est au format US, a  savoir : aaaa-mm-jj hh:mm:ss

Report this snippet  

You need to login to post a comment.