Using DBINFO function with utc_to_datetime option. If you require in DDMMYYYY format, use to_char().
Example :
> select name, dbinfo("utc_to_datetime",level0) level0 from sysdbstab;
name rootdbs
level0 2019-03-29 11:42:27
name sbspace
level0 2019-03-29 11:42:27
name sbspace_000
level0 2019-03-29 11:42:27
name dbs1
level0 2019-03-29 11:42:27
name dbs2
level0 2019-03-29 11:42:27
name temp1
level0 1970-01-01 10:00:00
name temp2
level0 1970-01-01 10:00:00
7 row(s) retrieved.
> !onstat -g arc
IBM Informix Dynamic Server Version 12.10.FC9 -- On-Line (Prim) -- Up 02:35:03 -- 1395428 Kbytes
num DBSpace Q Size Q Len Buffer partnum size scanner
Dbspaces - Archive Status
name number level date log log-position
rootdbs 1 0 03/29/2019.11:42 45 0x3b94d8
sbspace 2 0 03/29/2019.11:42 45 0x3b94d8
sbspace_000 3 0 03/29/2019.11:42 45 0x3b94d8
dbs1 4 0 03/29/2019.11:42 45 0x3b94d8
dbs2 5 0 03/29/2019.11:42 45 0x3b94d8
With to_char added.
> select to_char(dbinfo("utc_to_datetime",level0),'%d%m%Y') from sysdbstab;
(expression) 29032019
(expression) 29032019
(expression) 29032019
(expression) 29032019
(expression) 29032019
(expression) 01011970
(expression) 01011970
7 row(s) retrieved.
------------------------------
CASEYTAN
------------------------------
Original Message:
Sent: Thu March 05, 2020 11:23 PM
From: Saradhi Motamarri
Subject: Displaying date in DD MM YY format
Hi,
I am looking at sysdbstab for level0.
The value is stored as integer.
How do I display this value as normal date DDMMYYYY in an SQL statement,
Like: select level0 from sysdbstab;
#Informix