Oracle/MySql/SqlServer

一. 获取时间中的某个元素

oracle : to_char(sysdate,'hh24');

mySql : date_format('2008-08-08 22:23:00', '%W %M %Y');

sqlServer : Datename(minute,TIME);

二. 建立临时表

oracle:

mySql:

CREATE TEMPORARY TABLE temp SELECT * from student;SELECT * FROM temp;drop table temp;

sqlServer:

SELECT * INTO  #temp from studentSELECT * FROM #tempdrop table #temp