North American Network Operators Group

Date Prev | Date Next | Date Index | Thread Index | Author Index | Historical

Re: Unix Timestamp

  • From: Michael L. Barrow
  • Date: Mon Oct 22 20:04:31 2001

> > 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