nanog mailing list archives

Re: Unix Timestamp


From: "Michael L. Barrow" <michael () mlbarrow com>
Date: Mon, 22 Oct 2001 16:59:56 -0700


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.

Since you're using MySQL, you may want to look at the FROM_UNIXTIME()
function. It's buit-in and you can use it to do the conversion as part of
your INSERT statements.

--
Michael L. Barrow
P: 805.965.1314 F:781.240.5836


Current thread: