RE: ICONV/OCONV for unix internal timestamp (secs past 00:00 01/01/1970)
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 mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: ICONV/OCONV for unix internal timestamp (secs past 00:00 01/01/1970)
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 time as number of seconds past midnight GMT, Jan 1, 1970. Is there a conversion code to convert that to from external date time? If not, have you already written a custom conversion care to share? (I am NOT asking how to roll my own. I just don't want to do so if someone already has it, including figuring out flexability in output format.) Chuck Stevenson -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: ICONV/OCONV for unix internal timestamp (secs past 00:00 01/01/1970)
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 http://www.pickwiki.com/cgi-bin/wiki.pl?DateUtility . DateUtility(parseEpochTime,intTimeStamp) will return U2 Date Time based on the local machine time zone. This function could be used as a conversion by wrapping it and globally cataloguing it as $ParseEpochTime OCONV(intTimeStamp,'UParseEpochTime') Cheers, Stuart -Original Message- Behalf Of Stevenson, Charles unix generally keeps track of time as number of seconds past midnight GMT, Jan 1, 1970. Is there a conversion code to convert that to from external date time? If not, have you already written a custom conversion care to share? (I am NOT asking how to roll my own. I just don't want to do so if someone already has it, including figuring out flexability in output format.) Chuck Stevenson ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this email in error please notify the Spotless IS Support Centre (61 3 9269 7555) immediately who will advise further action. This footnote also confirms that this email message has been scanned for the presence of computer viruses. ** -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: ICONV/OCONV for unix internal timestamp (secs past 00:00 01/01/1970)
[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 to piggyback on it. thanks, cds -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users