Date:         Mon, 5 Jan 2009 16:06:34 -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:  <1764fdbb-b2a2-472d-ac1c-a74421d032df@v39g2000pro.googlegroups.com>
Content-Type: text/plain; charset="us-ascii"

11AUG08:06:00:00 (48+ years after the start of the epoch) is
approximately 1.5E9.  Your value is 1.2E12, approximately 1,000 times
further away from the start of the epoch or close to AD 48,000.  My
Language Concepts manual says AD 19,900 is as far as you can go.  I
would guess that sql is giving you something other than seconds.

Your value of 3155976000 prints as 03JAN2060:12:00:00 using datetime20.
on my 9.1.3 system.

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

Tried Gerhard's way, same with the asterisks. An example of the
timeStamp value in it's original form from the mysql datasource is
1229979606474

So far, what i've tried are:
1. use timestamp - 3155976000 and let format set to datetime.
2. use timestamp - 3155976000 and let format set to datetime20.
3. set format to datetime.
4. set format to datetime20.

All of the above gives me a display of asterisks.