HPD_HeldDesk Worklog timestamp conversion

2008-01-04 Thread brooksm
me how I can get the Work Log to display properly formatted timestamps in a direct sql query that looks like this:8/26/2006 2:36:22 PM and not like this: 1155331936 Thanks Brooks ARSystem 7.00 SQL Server 2005 -- View this message in context: http://www.nabble.com/HPD_HeldDesk-Worklog-timestamp

Re: HPD_HeldDesk Worklog timestamp conversion

2008-01-04 Thread brooksm
ODBC driver? Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of brooksm Sent: Friday, January 04, 2008 3:30 PM To: arslist@ARSLIST.ORG Subject: HPD_HeldDesk Worklog timestamp conversion Hello All I am using SQL

Re: HPD_HeldDesk Worklog timestamp conversion

2008-01-04 Thread Joe D'Souza
Of brooksm Sent: Friday, January 04, 2008 3:30 PM To: arslist@ARSLIST.ORG Subject: HPD_HeldDesk Worklog timestamp conversion Hello All I am using SQL Server Reporting Services for my reporting application and the ARSystem ODBC driver is throwing up errors when I use it to connect to ARSystem, so I

Re: HPD_HeldDesk Worklog timestamp conversion

2008-01-04 Thread Joe D'Souza
(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of brooksm Sent: Friday, January 04, 2008 4:56 PM To: arslist@ARSLIST.ORG Subject: Re: HPD_HeldDesk Worklog timestamp conversion Hey Joe- I'm using Visual Studio 2005 (Reporting Services) to connect to ARSystem. When I do use the AR ODBC driver I get

Re: HPD_HeldDesk Worklog timestamp conversion

2008-01-04 Thread brooksm
@ARSLIST.ORG Subject: Re: HPD_HeldDesk Worklog timestamp conversion Hey Joe- I'm using Visual Studio 2005 (Reporting Services) to connect to ARSystem. When I do use the AR ODBC driver I get this error: Column 'TABLE_CAT' does not belong to table Tables. It's also documented here: http