SELECt DATAbase_NAME AS "Database" FROM INFORMATION_SCHEMA.DATAbaseS WHERe DATAbase_NAME LIKE '%Data' AND DATAbase_OWNER = 'SYSADMIN' AND CREATED <= DATEADD(DAY,-1,current_timestamp()) ;
![[Snowflake]如何获取7天之前创建的数据库](http://www.mshxw.com/aiimages/31/335525.png "[Snowflake]如何获取7天之前创建的数据库")
SELECt DATAbase_NAME AS "Database" FROM INFORMATION_SCHEMA.DATAbaseS WHERe DATAbase_NAME LIKE '%Data' AND DATAbase_OWNER = 'SYSADMIN' AND CREATED <= DATEADD(DAY,-1,current_timestamp()) ;
名师互学网 版权所有 (c)2021-2022 ICP备案号：晋ICP备2021003244-6号
