use MySQL's FROM_UNIXTIME function: select FROM_UNIXTIME(date,"%m/%d/%Y") as us_date
-- Riley ----- Original Message ----- From: "John R. Brewster" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, August 08, 2002 11:42 AM 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]
