如何找到数据库中为时间格式的字段名？sql语句?

select a.COLUMN_NAME,b.COMMENTS,a.COLUMN_ID,a.NULLABLE ,a.DATA_TYPE,a.DATA_DEFAULT,a.DATA_LENGTH,a.DATA_PRECISION,a.DATA_SCALE
from DBA_TAB_COLUMNS a,DBA_COL_COMMENTS b
where a.OWNER=b.OWNER and a.TABLE_NAME=b.TABLE_NAME and a.COLUMN_NAME=b.COLUMN_NAME
and LOWER(a.TABLE_NAME)=需要查询的表名
and LOWER(a.OWNER)='dddase'此表的所有者
and a.data_type='DATE'--要查的数据类型
order by a.COLUMN_ID

执行此语句前提必须要有DBA权限
此方法为ORACLE中查询所用

SELECT COL.[name] AS '列名'
FROM SYSCOLUMNS COL INNER JOIN SYSTYPES TYPE
ON COL.xtype = TYPE.xtype
WHERE COL.[ID] = OBJECT_ID('表名') AND TYPE.[NAME]= 'datetime'