一. 获取时间中的某个元素
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 student
SELECT * FROM #temp
drop table #temp