English | 正體中文 | 简体中文

SQL year,month,day,now


范例资料表 : Orders (以下范例皆用此表当作资料来源)
Keyid OrderNo CustomerName SalePrice Quantity OrderDate
1 20101213095 John 3500 10 2010-12-13
2 20100620135 Jimmy 2509 22 2010-06-20
3 20100620392 Vincent 7200 5 2010-06-20
4 20100530006 John 9200 50 2010-05-30
5 20100515129 Vincent 100 50 2010-05-29


Example
从一个日期栏位里分别选择出年份、月份和日期

Sytax : SELECT YEAR(column_name), MONTH(column_name), DAY(column_name) FROM table_name
SQL
SELECT YEAR(OrderDate), MONTH(OrderDate), DAY(OrderDate), OrderDate FROM Orders 

会输出结果
Year Month Day OrderDate
2010 12 13 2010-12-13
2010 6 20 2010-06-20
2010 6 20 2010-06-20
2010 5 30 2010-05-30
2010 5 29 2010-05-29


Example
显示资料库目前时间

Sytax : SELECT NOW()
SQL
SELECT NOW()

会输出结果
Now()
2012-01-07 22:27:40

© 2012 PureExample.com contact