Hello Everyone,

I’ve found the solution in the meantime:

SELECT sys.epoch(str_to_timestamp('2018-02-15 10:04:00', '%Y-%m-%d %H:%M:%S'));

Best regards,

Marcell

From: users-list [mailto:users-list-bounces+marcell.bernat=arh.hu@monetdb.org] On Behalf Of Bernát Marcell
Sent: Wednesday, February 14, 2018 11:32 AM
To: users-list@monetdb.org
Subject: Converting a timestamp to a UNIX timestamp

Dear MonetDB users,

I’m looking for a way to convert a timestamp (or timestamp string) like „2018-02-14 23:59:59” to a UNIX timestamp using MonetDB’s functions. In MySQL this can be done using the function UNIX_TIMESTAMP(), so I’m looking for the MonetDB equivalent of that, if it exists.

I found sys.epoch(), but that does the opposite of what I need.

Thanks in advance.

Best regards,

Marcell