Warning: Undefined array key "HTTP_REFERER" in /www/wwwroot/prod/www.enjoyasp.net/wp-content/plugins/google-highlight/google-hilite.php on line 58
CREATE FUNCTION [dbo].[UNIX_TIMESTAMP]
(
@DATE DATETIME=''
)
RETURNS DECIMAL
AS
BEGIN
--注意时区，北京时间统一减8变成格林尼治时间
IF @DATE='' SET @DATE=GETDATE()
SET @DATE=DATEADD(HOUR,-8,@DATE)
RETURN DATEDIFF(SECOND,'1970-01-01',@DATE)
END
CREATE FUNCTION [dbo].[FROM_UNIXTIME]
(
@i DECIMAL
)
RETURNS VARCHAR(20)
AS
BEGIN
RETURN CONVERT(VARCHAR(20),DATEADD(SECOND,@i+28800,'1970-01-01'),120) --北京时间要加回8*3600=28800秒
END