topic Re: sql query using date stamp in SAS Programming https://communities.sas.com/t5/SAS-Programming/sql-query-using-date-stamp/m-p/93224#M257532 <HTML><HEAD></HEAD><BODY><P>I should say that the following works:</P><P>WHERE ETL_PRCS_START_TS = '23AUG2012:16:58:12.000000'dt</P><P></P><P>but I'm working within netezza, I think this should be a question posted to another forum.</P></BODY></HTML> Fri, 12 Oct 2012 15:51:28 GMT Steelers_In_DC 2012-10-12T15:51:28Z sql query using date stamp https://communities.sas.com/t5/SAS-Programming/sql-query-using-date-stamp/m-p/93223#M257531 <HTML><HEAD></HEAD><BODY><P>I am trying to search for a specific datestamp and not sure what the correct syntax is using proc sql, to be more precise I'm pulling data from netezza using sas.&nbsp; I want to find the following:</P><P></P><P>where ETL_PRCS_START_TS = 23AUG2012:16:58:12.000000</P><P></P><P>Is there an easy way to format that date?</P></BODY></HTML> Fri, 12 Oct 2012 15:24:58 GMT https://communities.sas.com/t5/SAS-Programming/sql-query-using-date-stamp/m-p/93223#M257531 Steelers_In_DC 2012-10-12T15:24:58Z Re: sql query using date stamp https://communities.sas.com/t5/SAS-Programming/sql-query-using-date-stamp/m-p/93224#M257532 <HTML><HEAD></HEAD><BODY><P>I should say that the following works:</P><P>WHERE ETL_PRCS_START_TS = '23AUG2012:16:58:12.000000'dt</P><P></P><P>but I'm working within netezza, I think this should be a question posted to another forum.</P></BODY></HTML> Fri, 12 Oct 2012 15:51:28 GMT https://communities.sas.com/t5/SAS-Programming/sql-query-using-date-stamp/m-p/93224#M257532 Steelers_In_DC 2012-10-12T15:51:28Z