下面的代码:
date_format(date,'%Y-%m-%d');
将把时间格式化为日期形式的字符串---(2007-03-16)
下面是从网上搜来的参数列表:
Example Date: 1st April 2005 Replace date with the name of your date field... | |
date_format String | Example |
'%e/%c/%Y' | 1/4/2005 UK |
'%c/%e/%Y' | 4/1/2005 US |
'%d/%m/%Y' | 01/04/2005 UK |
'%m/%d/%Y' | 04/01/2005 US |
'%e/%c/%Y %H:%i' | 1/4/2005 12:30 UK |
'%c/%e/%Y %H:%i' | 4/1/2005 12:30 US |
'%d/%m/%Y %H:%i' | 01/04/2005 12:30 UK |
'%m/%d/%Y %H:%i' | 04/01/2005 12:30 US |
'%e/%c/%Y %T' | 1/4/2005 12:30:10 UK |
'%c/%e/%Y %T' | 4/1/2005 12:30:10 US |
'%d/%m/%Y %T' | 01/04/2005 12:30:10 UK |
'%m/%d/%Y %T' | 04/01/2005 12:30:10 US |
'%a %D %b %Y' | Fri 1st Apr 2005 |
'%a %D %b %Y %H:%i' | Fri 1st Apr 2005 12:30 |
'%a %D %b %Y %T' | Fri 1st Apr 2005 12:30:10 |
'%a %b %e %Y' | Fri Apr 1 2005 |
'%a %b %e %Y %H:%i' | Fri Apr 1 2005 12:30 |
'%a %b %e %Y %T' | Fri Apr 1 2005 12:30:10 |
'%W %D %M %Y' | Friday 1st April 2005 |
'%W %D %M %Y %H:%i' | Friday 1st April 2005 12:30 |
'%W %D %M %Y %T' | Friday 1st April 2005 12:30:10 |