SQL YEAR,MONTH,DAY,NOW

Example Data Table : Orders (All of the below examples use this table as datasource)
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
To get year, month, day from a date column
 
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

will output
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
To get current time
Sytax : SELECT NOW()
SQL
SELECT NOW()

will output
Now()
2012-01-07 22:27:40
comments powered by Disqus