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?