[43682] in North American Network Operators' Group
Re: Unix Timestamp
daemon@ATHENA.MIT.EDU (Michael L. Barrow)
Mon Oct 22 20:02:26 2001
Message-ID: <041201c15b55$a6927b50$9865fea9@barrowacer>
From: "Michael L. Barrow" <michael@mlbarrow.com>
To: "Brandon Handeland" <Brandon@wyoming.com>
Cc: <nanog@merit.edu>
Date: Mon, 22 Oct 2001 16:59:56 -0700
MIME-Version: 1.0
Content-Type: text/plain;
charset="Windows-1252"
Content-Transfer-Encoding: 7bit
Errors-To: owner-nanog-outgoing@merit.edu
> > 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
