Date:         Mon, 16 Apr 2007 15:20:17 -0400
Reply-To:     Raghav Adimulam <RaghavAdimulam@WESTAT.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Raghav Adimulam <RaghavAdimulam@WESTAT.COM>
Subject:      Re: Exact hourly value
Comments: To: Xiao Tang <glionswiss@GMAIL.COM>
In-Reply-To:  A<200704161902.l3GIwRQs021718@mailgw.cc.uga.edu>
Content-Type: text/plain; charset="us-ascii"

Xiao,
The second value is zero because, the timepart function returns the
number of seconds elapsed on that particular date (i.e. the number of
seconds since midnight). Also note that you have two different datepart
values in your data.

HTH,
Raghav

-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of
Xiao Tang
Sent: Monday, April 16, 2007 3:03 PM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Exact hourly value


I have some filed like this:

04mar2007:23:59:59
05mar2007:00:00:00

I use timepart to extract hourly value and sas return the first value
equals to 86399 but return the second value equals to 0. Actually I
expect the second value could be 86400. Why the second value could be 0.
Thanks,

Xiao