当前日期:
SQLserver:select getdate();
mysql : select now();
oracle : select sysdate from dual_tbl;
时间和日期相加:
date '2010-12-31' +interval '1' day 2011-01-01
sqlserver : select date_hire , dateadd(month,1,date_hire) from employee_pay_tbl;
oracle : select date_hire ,add_months(date_hire , 1) from employee_pay_tbl;
日期上增加一天: select date_hire ,date_hire+1 from employee_pay_tbl where emp_id ='0000';
mysql : 把日期转换为整数在进行加法运算:select date_hire ,date_add(date_hire, interval 1 day ), date_hire +1 from employee_pay_tbl where emp_id ='0000';
日期转换为字符串:
sqlserver : select date_hire=datename(month,date_hire) from employee_pay_tbl;
oracle : select date_hire , to_char(date_hire,'month,dd,yyyy') hire from employee_pay_tbl;
字符串转换为日期:
MySQL: select str_to_date ('01/01/2010 12:00:00 am' , '%m/%d/%y %h:%i:%s %p') as format_date from employee_pay_tbl;
sqlserver : select convert (datetime,'02/25/2010 12:00:00 am') as format_date from employee_pay_tbl;