I have a table which stores sessions information

It stores the date when the session was created in UNIX format how can I use
query and get that date in ISO format ?

Example of the date is

LASTACCESS
--------------------
1125064679406
1125064782078

The format of the field in database is as hilighted below

Column Type Type
name schema name Length Scale
Nulls
------------------------------ --------- ------------------ -------- -----
-----
ID SYSIBM VARCHAR 128 0
No
PROPID SYSIBM VARCHAR 128 0
No
APPNAME SYSIBM VARCHAR 128 0
Yes
LISTENERCNT SYSIBM SMALLINT 2 0
Yes
LASTACCESS SYSIBM BIGINT 8 0
Yes
CREATIONTIME SYSIBM BIGINT 8 0
Yes
MAXINACTIVETIME SYSIBM INTEGER 4 0
Yes
USERNAME SYSIBM VARCHAR 256 0
Yes
SMALL SYSIBM VARCHAR 3122 0
Yes
MEDIUM SYSIBM LONG VARCHAR 32700 0
Yes
LARGE SYSIBM BLOB 2097152 0
Yes

Thanks


Ajay Bohra
Business Analyst
Retail Variations Plc ,Windrush House , Windrush Park, Witney , Oxon, OX29
7DX
Tel 01993 770553 Fax 01993 776490

Visit us at www.retailvariations.com <http://www.retailvariations.com>

Shop Online with us at

www.past-times.com <http://www.past-times.com/>
gift ideas inspired by the past
www.oceanuk.com <http://www.oceanuk.com>
style for the modern home

Our Blogs
http://pasttimes.typepad.com/ <http://pasttimes.typepad.com/>
Past Times Blog


DB2 & UDB email list listserv db2-l LazyDBA home page