converting dbf date field to sql date field

Question

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Adam Haines SSC-Insane Points: 23217 More actions · Answer 1

What does the date look like when it is imported?

davidtlu Say Hey Kid Points: 672 More actions · Answer 2

I just figure it out. Apparently the apps stores it in Unix Time (UTC.) So I wrote a function to convert it

thanks anyway

Adam Haines SSC-Insane Points: 23217 More actions · Answer 3

Can you post a sample and the solution you came up with? This will benifit others who may run into the same problem.

davidtlu Say Hey Kid Points: 672 More actions · Answer 4

no problem...it was very simple once...

CREATE FUNCTION

(

@inputDT int

)

RETURNS datetime

AS

BEGIN

RETURN DATEADD(SECOND, @inputDT, '1/1/1970')

END

GO