Unix Timestamp
Michael L. Barrow
michael at mlbarrow.com
Mon Oct 22 23:59:56 UTC 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
More information about the NANOG
mailing list