Unix epoch date

[Phil (OmnisList)]

Seems it squashed the text together after copying from Omnis..

Calculate ldDate as dat('1 Jan 1970 00:00')
Calculate ldDate as dadd(kSecond,1673643173,ldDate)

regards
Phil Potter
Based in Chester in the UK.

On 16/01/2023 22:46, Phil (OmnisList) wrote:
> Xavier,
>
> Simple Maths?
>
> CalculateldDateas dat('1 Jan 1970 00:00')
>
> CalculateldDateas dadd(kSecond,1673643173,ldDate)
>
>
> Does this work for you?
>
> regards
> Phil Potter
> Based in Chester in the UK.
>
> On 16/01/2023 22:19, IT wrote:
>> Hi,
>>
>> Is there any omnis function to convert unix date to omnis date?
>>
>> I can use postgresql to convert
>>
>> select to_timestamp(1673643173)
>>
>> but not found an omnis way. Any clues?
>>
>> regards
>>
>> xavier
>> _____________________________________________________________
>> Manage your list subscriptions athttps://lists.omnis-dev.com
>> Start a new message ->mailto:omnisdev-en at lists.omnis-dev.com 
> _____________________________________________________________
> Manage your list subscriptions at https://lists.omnis-dev.com
> Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com