Is there a way to do a SQL Convert?

[GregThompson]

I want to basically do this:

select convert(datetime, dateadd(s, 1228147305, '1/1/1970'))) = '2008-12-01 06:00:04.000')

But in AutoIT? Is this possible?

[ProgAndy]

There is a func called _DateAdd

#include <Date.au3>
$date = _DateAdd("s",1228147305,"1970/1/1 00:00:00")
MsgBox(0, '', $date)

[GregThompson]

There is a func called _DateAdd

#include <Date.au3>
$date = _DateAdd("s",1228147305,"1970/1/1 00:00:00")
MsgBox(0, '', $date)

thanks a bunch!

[GregThompson]

Let me rephrase the question... I want to take a DATE/TIME, and convert it to the long number, not the other way around.

[GregThompson]

Anything?