I'm writing a DTS package which queries a Remedy database. Datetime in Remedy is handled as seconds since 1 January 1970. My question is, how do I compare SQL datetime to Remedy datetime?
SELECT * FROM RemedyTable WHERE getdate() >= [datefield]
I tried to convert the getdate() into seconds using DATEDIFF, but I don't think this can run on Remedy.