sql 日期转oracle,将SQL Server日期转换为Oracle

我把杰夫的答案，并把它包在返回一个字符串TO_DATE的功能。

CREATE FUNCTION [dbo].[fnOracleTo_DateStringFromMsSqlDate]

(

@InputDate datetime

)

RETURNS varchar(100)

AS

BEGIN

DECLARE @year varchar(4),

@month varchar(3),

@day varchar(2),

@hour varchar(2),

@minute varchar(2),

@second varchar(2),

@date smalldatetime,

@OracleTime varchar(50),

@returnString varchar(100)

SET @year = YEAR(@InputDate)

SET @month = Month(@InputDate)

SET @day = DAY(@InputDate)

-------------------------------------------------------------------------

SET @hour = DATEPART(HH, @InputDate)

SET @minute = DATEPART(MINUTE, @InputDate);

SET @second = datepart(SECOND, @InputDate);

SET @OracleTime = @day + '-' + @month + '-' + @year + ' ' + @hour + ':' + @minute + ':' + @second ;

set @returnString = 'to_date(' + char(39) + @OracleTime + char(39) + ',' + char(39) + 'DD-MM-YYYY HH24:MI:SS' + char(39) + ')'

return @returnString;

END