https://communities.sas.com/t5/SAS-Enterprise-Guide/How-to-compare-datetime-value-02JAN2007-00-00-00/m-p/25489#M3790 I m using a query<BR /> proc sql;<BR /> select count(*) into :mCount from AMDEXSTG.EX_AR1_ACCOUNT where CANDIDATE_FILE_EXTRACT_DATE = 02JAN2007:00:00:00;<BR /> quit;<BR /> but it is throwing the syntax error.Please for this query Thu, 30 Apr 2009 11:27:45 GMT deleted_user 2009-04-30T11:27:45Z https://communities.sas.com/t5/SAS-Enterprise-Guide/How-to-compare-datetime-value-02JAN2007-00-00-00/m-p/25489#M3790 I m using a query<BR /> proc sql;<BR /> select count(*) into :mCount from AMDEXSTG.EX_AR1_ACCOUNT where CANDIDATE_FILE_EXTRACT_DATE = 02JAN2007:00:00:00;<BR /> quit;<BR /> but it is throwing the syntax error.Please for this query Thu, 30 Apr 2009 11:27:45 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/How-to-compare-datetime-value-02JAN2007-00-00-00/m-p/25489#M3790 deleted_user 2009-04-30T11:27:45Z https://communities.sas.com/t5/SAS-Enterprise-Guide/How-to-compare-datetime-value-02JAN2007-00-00-00/m-p/25490#M3791 When using SAS Dates you would write '02JAN2007'd and when using datetime try '02jan07:0:00:00'<B>dt</B><BR /> <BR /> Whether this will work also depends on what database "AMDEXSTG" is, and how you connect to it (ODBC or SAS/Connect) - it not always that a SAS datetime is translated properly when transformed to another database. Thu, 30 Apr 2009 12:57:46 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/How-to-compare-datetime-value-02JAN2007-00-00-00/m-p/25490#M3791 GertNissen 2009-04-30T12:57:46Z