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:
- Re: Unix Timestamp, (continued)
- Re: Unix Timestamp Barry Shein (Oct 22)
- Re: Unix Timestamp Greg A. Woods (Oct 22)
- Re: Unix Timestamp Chrisy Luke (Oct 22)
- Re: Unix Timestamp Chris Adams (Oct 22)
- Re: Unix Timestamp Greg A. Woods (Oct 22)
- Re: Unix Timestamp Michael L. Barrow (Oct 22)
- Re: Unix Timestamp Henry Yen (Oct 22)
- Re: Unix Timestamp Owen DeLong (Oct 23)
- Re: Unix Timestamp Nathan Stratton (Oct 22)
- Re: Unix Timestamp Michael L. Barrow (Oct 22)