sql query using date stamp

Reply
Valued Guide
Posts: 858

sql query using date stamp

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.  I want to find the following:

where ETL_PRCS_START_TS = 23AUG2012:16:58:12.000000

Is there an easy way to format that date?

Valued Guide
Posts: 858

Re: sql query using date stamp

I should say that the following works:

WHERE ETL_PRCS_START_TS = '23AUG2012:16:58:12.000000'dt

but I'm working within netezza, I think this should be a question posted to another forum.

Ask a Question
Discussion stats
  • 1 reply
  • 191 views
  • 0 likes
  • 1 in conversation