时间戳时间转

-- MySQL
SELECT FROM_UNIXTIME(875996580); -- 时间戳int转时间
SELECT UNIX_TIMESTAMP('1997-10-04 22:23:00') -- 时间转，时间戳int


-- MSSQL
SELECT DATEDIFF(s, '19700101',GETDATE()) 
SELECT DATEADD(hh,8, DATEADD(s, 1483228626 , '19700101') )

-- ORACLE,注意Oracle是毫秒

SELECT TO_CHAR(1483243932000 / (1000 * 60 * 60 * 24) + 
TO_DATE('1970-01-01 08:00:00', 'YYYY-MM-DD HH:MI:SS'), 'YYYY-MM-DD HH24:MI:SS') AS CDATE 
FROM DUAL;-- 毫秒转换为日期

SELECT TO_NUMBER(TO_DATE('2017-01-01 12:12:12', 'YYYY-MM-DD HH24:MI:SS') - 
TO_DATE('1970-01-01 8:0:0', 'YYYY-MM-DD HH24:MI:SS')) * 24 * 60 * 60 * 1000 
FROM DUAL; -- 日期转换毫秒

PostgreSQL:

select extract(epoch from to_timestamp('2018-01-01 00:00:00','yyyy-MM-DD hh24:mi:ss')); -- 时间转秒
select to_timestamp(1514736000) ; -- 秒转时间

其他：

SELECT 
CONCAT('CREATE TABLE t_app_data_' ,DATE_FORMAT(DATE_ADD('2021-01-01',INTERVAL help_topic_id DAY),'%Y%m%d')
, ' PARTITION OF t_app_data FOR VALUES FROM (' , UNIX_TIMESTAMP(DATE_ADD('2021-01-01',INTERVAL help_topic_id DAY))
,') TO (', UNIX_TIMESTAMP(DATE_ADD('2021-01-01',INTERVAL help_topic_id+1 DAY)),'-1);') d
-- ,DATE_ADD('2021-01-01',INTERVAL help_topic_id DAY)
FROM help_topic

SELECT CONCAT( 'ALTER TABLE t_dwd_tb1 ADD PARTITION "'
,DATE_FORMAT(DATE_ADD('2021-01-02 00:00:00',INTERVAL help_topic_id DAY),'%Y%m%d')  
,'" START (',SUBSTRING(UNIX_TIMESTAMP(DATE_ADD('2021-01-02 00:00:00',INTERVAL help_topic_id DAY)),1,10) 
,') END (' ,SUBSTRING(UNIX_TIMESTAMP(DATE_ADD('2021-01-03 00:00:00',INTERVAL help_topic_id DAY)),1,10) 
,') exclusive WITH (appendonly=TRUE,compresslevel=1);' ) ddl 
FROM help_topic 
WHERE help_topic_id<=210 
LIMIT 0, 1000;