Content Management and Capture

Good evening,

some dates are encoded in a numeric way (BIGINT/SMALLINT) in the DB2 database of OnDemand :

for example, column START_DATE of ARSSEG table (looks like 18213)

or column POST_DATE of ARSSEG table (looks like 1648736172).

How can I convert them in a human readable way when I request the database (in date or timestamp formats, or trunc in year/month/day etc ...) ?

Thanks in advance

Regards

------------------------------
Manuel PAITREAULT
------------------------------

Hi,

theese attributes are stored in a Unix Timestamp format (generally it represents number of seconds since Jan 01 1970. (UTC)). For example -> 1648736172 represents Thu Mar 31 2022 14:16:12 GMT+0000.

You can convert theese timestamps for example here (but there are a lot of conversion sites online etc.) - https://www.unixtimestamp.com/

Have a nice day!

Petr

Good evening,

some dates are encoded in a numeric way (BIGINT/SMALLINT) in the DB2 database of OnDemand :

for example, column START_DATE of ARSSEG table (looks like 18213)

or column POST_DATE of ARSSEG table (looks like 1648736172).

How can I convert them in a human readable way when I request the database (in date or timestamp formats, or trunc in year/month/day etc ...) ?

Thanks in advance

Regards

------------------------------
Manuel PAITREAULT
------------------------------

Thanks a lot for your quick reply Petr.

I had noticed that I could convert manually and individually these numerics with IBM tool arsdate, but I would like to manipulate them directly in (PL-)SQL commands. For example, how could I select rows in a table (with a SQL where clause condition) for a specific year ?

Thanks

Hi,

theese attributes are stored in a Unix Timestamp format (generally it represents number of seconds since Jan 01 1970. (UTC)). For example -> 1648736172 represents Thu Mar 31 2022 14:16:12 GMT+0000.

You can convert theese timestamps for example here (but there are a lot of conversion sites online etc.) - https://www.unixtimestamp.com/

Have a nice day!

Petr

Good evening,

some dates are encoded in a numeric way (BIGINT/SMALLINT) in the DB2 database of OnDemand :

for example, column START_DATE of ARSSEG table (looks like 18213)

or column POST_DATE of ARSSEG table (looks like 1648736172).

How can I convert them in a human readable way when I request the database (in date or timestamp formats, or trunc in year/month/day etc ...) ?

Thanks in advance

Regards

------------------------------
Manuel PAITREAULT
------------------------------

Hi Manuel,

maybe this approach can help (eg. create a function and then use it in a SQL query):

https://ibexoft.com/converting-oracle-date-types-and-phpunix-timestamps/

Petr

Thanks a lot for your quick reply Petr.

I had noticed that I could convert manually and individually these numerics with IBM tool arsdate, but I would like to manipulate them directly in (PL-)SQL commands. For example, how could I select rows in a table (with a SQL where clause condition) for a specific year ?

Thanks

Hi,

theese attributes are stored in a Unix Timestamp format (generally it represents number of seconds since Jan 01 1970. (UTC)). For example -> 1648736172 represents Thu Mar 31 2022 14:16:12 GMT+0000.

You can convert theese timestamps for example here (but there are a lot of conversion sites online etc.) - https://www.unixtimestamp.com/

Have a nice day!

Petr

Good evening,

some dates are encoded in a numeric way (BIGINT/SMALLINT) in the DB2 database of OnDemand :

for example, column START_DATE of ARSSEG table (looks like 18213)

or column POST_DATE of ARSSEG table (looks like 1648736172).

How can I convert them in a human readable way when I request the database (in date or timestamp formats, or trunc in year/month/day etc ...) ?

Thanks in advance

Regards

------------------------------
Manuel PAITREAULT
------------------------------