Itgensql035 : UNIX_TIMESTAMP datatype no existing anymore

[sda]

It seems UNIX_TIMESTAMP has disappeared in recent upgrades both on Query Tool 25.0.127 and Invantive Cloud:

select UNIX_TIMESTAMP

Response:

itgensql035
Unknown identifier ‘UNIX_TIMESTAMP’.
There are no similar identifiers.

Is it an intended behaviour?

[sda]

It seems the right call is

select unix_timestamp()

Also previously we were multiplying the result by 1000 which seems not necessary anymore.

[forums]

Yes, that is correct. Starting at least release 25.0, it is always written as a function such as:

select unix_timestamp()
,      unix_timestamp(sysdateutc)
,      unix_timestamp(to_date('99991231235959', 'YYYYMMDDHH24MISS'))
,      from_unixtime(from_unixtime(unix_timestamp(sysdate)) - sysdate)

Looking back to previous releases till April 2022, the () notation has always been used as test cases. We were not aware that a variant without () worked and was in actual use.

Great that you have been able to resolve it.

We have been unable to find a variant of unix_timestamp which uses UNIX epoch timestamp in milliseconds. The value is always in seconds since 01-01-1970.

Possible output values range from -62135593200 (01-01-0001) to +253402300799 (31-12-9999 23:59:59).