Date:         Mon, 5 Jan 2009 16:47:50 -0800
Reply-To:     "Schwarz, Barry A" <barry.a.schwarz@BOEING.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Schwarz, Barry A" <barry.a.schwarz@BOEING.COM>
Subject:      Re: How to convert unix time stamp to SAS time stamp
In-Reply-To:  <0ea74805-892d-44ba-ae88-744d881dbdd2@z28g2000prd.googlegroups.com>
Content-Type: text/plain; charset="us-ascii"

Not possible.  An odd number of seconds after midnight will always yield
and odd value for seconds in the time.  In SAS
        06jan2009:11:05:12 is 1546859112
        01jun2009:11:05:12 is 1559473512

Both numbers are three orders of magnitude smaller than your value.  Is
sql giving you milliseconds instead of seconds?

-----Original Message-----
From: Lilian
Sent: Monday, January 05, 2009 4:18 PM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Re: How to convert unix time stamp to SAS time stamp

1231200312179 translates to 1/6/2009 11:05:12