取系统当前日期:
oracle:
select sysdate from dual;
select systimestamp from dual;
db2:
select current date from sysibm.sysdummy1(or values current date)
select current timestamp from sysibm.sysdummy1(or values current timestamp )
sybase:
select getdate() 类别: Database 查看评论
Link URL: http://hi.baidu.com/xmltiger/blog/item/7d8edb1794209859f2de321d.html
oracle:
select sysdate from dual;
select systimestamp from dual;
db2:
select current date from sysibm.sysdummy1(or values current date)
select current timestamp from sysibm.sysdummy1(or values current timestamp )
sybase:
select getdate() 类别: Database 查看评论
Link URL: http://hi.baidu.com/xmltiger/blog/item/7d8edb1794209859f2de321d.html
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/20533469/viewspace-580433/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/20533469/viewspace-580433/