Re: Unix Timestamp

["Steven M. Bellovin" <smb () research att com>]

In message <5.1.0.14.2.20011022123839.05490760 () calamity wyoming com>, Brandon H
andeland writes:
> Does anyone have a formula to convert a unix time stamp into the current time?
>
> I know it is January 1st, 1970, in UTC format.  Just need some example code.
>
> I'm trying to export some data from a HP/UX box into a MSSQL database and 
> need to use the timestamp feature of MSSQL.

How accurate does your conversion need to be?  Do you need timezones?  
Daylight time?

On any Unix system, including the open-source clones, grab a copy of 
ctime.c; its job is to do exactly that.  If you want to approximate the 
answer -- well, there are 86400 seconds/day, and either 365 or 366
days/year.  The remaind when dividing by 86400 is the number of seconds 
into the current day, in UTC.

                --Steve Bellovin, http://www.research.att.com/~smb
                Full text of "Firewalls" book now at http://www.wilyhacker.com