Unix epoch date

[IT]

Hi Phil,

Following your sample code I resolved to do in one line:

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

Thank you for your assistance,

xavier


> El 16 ene 2023, a las 23:48, Phil (OmnisList) <phil at pgpotter.co.uk> escribió:
> 
> 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 
> _____________________________________________________________
> Manage your list subscriptions at https://lists.omnis-dev.com
> Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com