Numeric to DateTime Syntax

[ddeegan]

Hello

I have fields (data type=decimal) to import into another field (data type=datetime)

The format of the numeric field is YYYYMMDD (20060801)

But, some of the numeric fields are equal to 0 or null.

What is the proper syntax for an insert statement?

Thanks in advance
Dave

 

[gmmastros]

Declare @Temp Decimal(10,0)

Set @Temp = 0

Select Convert(DateTime, Convert(VarChar(10), Nullif(@Temp, 0)))

If the value is NULL or 0, NULL will be returned. If the value is anything else, the conversion will take place.

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom