Going into the sql or coming out of the data; Going into it, I would try to use AxKit::XSP::Util's time tag.
Coming out, I my self would format the SQL statement to return it formatted; TO_CHAR(date_field,"DD/MM/YYYY") as long as your DB supports the TO_CHAR. -Don -----Original Message----- From: John R. Brewster [mailto:[EMAIL PROTECTED]] Sent: Thursday, 08 August, 2002 11:43 To: [EMAIL PROTECTED] Subject: Time I am using XSP esql: to get mysql data. Works great, except one field is the time in seconds. So, I get a great string of numbers. How can I translate them in the xsp to a real date/time? for example: <date>1027601820</date> to <date>08/04/2002</date> Thanks, John ------------------------------------------------------------------------ -------- John R. Brewster Director Software Testing Department Mediation Group Intec Telecom Systems WWW: http://www.intec-telecom-systems.com Building G, 4th Floor E-Mail: [EMAIL PROTECTED] 5775 Peachtree-Dunwoody Road Voice: 404 705.2818 / 2800 Atlanta, GA 30342 Fax: 404 705.2805 --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
