Date:         Fri, 15 Aug 2008 06:15:15 -0700
Reply-To:     Patrick <patrick.matter@GMX.CH>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Patrick <patrick.matter@GMX.CH>
Organization: http://groups.google.com
Subject:      Re: The syntax of the string representation of a datetime value is
Comments: To: sas-l@uga.edu
Content-Type: text/plain; charset=ISO-8859-1

Ooops! I forgot the last minute. Better use:
where mc.START_DT >= TIMESTAMP ('2005-01-01 00:00:00')
      and mc.END_DT < TIMESTAMP ('2008-01-01 00:00:00')

or:
where mc.START_DT >= TIMESTAMP ('2005-01-01 00:00:00')
      and mc.END_DT <= TIMESTAMP ('2007-12-31 23:59:59')

I actually thinkt that 24 doesn't exist (and would result in an
error).
I prefer the first variant because there you're sure that you will get
the last millisecond whatever the precision is.

Patrick