seconds past midnight GMT, Jan 1, 1970.
Is there a conversion code
yeah .. something like:
pick DATE() = INT(unixtime/86400)+732
pick TIME() = MOD(unixtime,86400)
which makes:
unixtime = (pick DATE() - 732) * 86400 + pick TIME()
and PICK time is always local time, not GMT
--
u2-users
Are you asking about the 'MTHS' conversion code?
- Original Message -
From: Stevenson, Charles [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, April 28, 2004 1:47 PM
Subject: ICONV/OCONV for unix internal timestamp (secs past 00:00
01/01/1970)
unix generally keeps track of
Chuck,
you need to worry about time zone when rendering the unix epoch time as it
is UTC (aka GMT) based. A simple conversion of the unix epoch time to U2
date/time will be incorrect unless you are in Britain in the winter - and
who'd be there then ;-)
Have a look at
[mailto:[EMAIL PROTECTED] On Behalf Of Stuart Boydell
Have a look at http://www.pickwiki.com/cgi-bin/wiki.pl?DateUtility .
DateUtility(parseEpochTime,intTimeStamp) will return U2
Date Time based on the local machine time zone.
Now that's rich. There's a lot there.
Looks like maybe good