Re: AIE import unix timestamp in millisecond format

2008-05-19 Thread googerb
As soon as I posted this, I discovered I could successfully use a syntax like this: SQL|SELECT CAST (LastScanDate / 1000 as int) FROM On May 19, 4:41 pm, googerb <[EMAIL PROTECTED]> wrote: > Has anyone been able to import a timestamp from an external database > using AIE data mappings, where the

AIE import unix timestamp in millisecond format

2008-05-19 Thread googerb
Has anyone been able to import a timestamp from an external database using AIE data mappings, where the souce data is an a millisecond unix timestamp format. I can execute SQL statements directly in the source database to maniuplate the data, but AIE will not import the data due to it being in mil