Im trying to pull data from a pervaive table via a DTS in SQL Server. The query below returns data in the pervasive control center but when I try to run the DTS it does not return anything. I think it is because it reads the date as a string not as a date. (I had that problem in a page I was working on) I was wondering if there is a Cast or Convert function I can use. I tried using cast like you see below but it did not work.
SELECT Com_Pat_Id, Com_Line, Com_Usr_Id_Added, Com_Date_Added FROM table1 WHERE Com_Date_Added >CAST( '2005-07-24' AS datetime) AND Com_Pra_id = 'ADS'
Thanks in advance
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.