Hi.

 

I want to update the ACQUISITIONDATE column in the Resources table.

 

As the column only accepts BigInt data I want to convert the relevant date to this value.

 

I have tried converting the date using

 

SELECT  dbo . unix_timestamp ( '2008-09-14 00:00:00' )

 

which returns the value 1221346800

 

However, when I update the column and view the data in ServiceDesk it displays

 

Jan 15, 1970

 

If I convert 1221346800 back to a date using

 

SELECT dbo .from_unixtime(1221346800)

 

I get

 

2008-09-14 00:00:00.000

 

Could you tell me where I am getting an incorrect date in the UI?

 

Thanks,

 

Brendan