Purchase Order Dates - custom query

Purchase Order Dates - custom query

Hi .. I'm trying to write a custom purchase order query, and cannot find any specific document that details how to 'decode' the dates.

am using: Service Desk 7.0.0 Build 7012, MS-SQL server

My query is:

SELECT po.DATEORDERED "Ordered Date",po.POCUSTOMID "PO Number",po.PONAME "PO Name",paao.NAME "Vendor Name",pos.STATUSNAME "PO Status",po.TOTALPRICE "Total Price" FROM PurchaseOrder po LEFT JOIN POStatus pos ON po.STATUSID=pos.STATUSID LEFT JOIN VendorDefinition pvd ON po.VENDORID=pvd.VENDORID LEFT JOIN AaaOrganization paao ON pvd.VENDORID=paao.ORG_ID ORDER BY 1

Dates are displayed as long numbers. eg "1172819273386" ..

How are these translated into human readable dates?

thanks,
Kevin












                    New to ADSelfService Plus?