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
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
participants (1)
-
Bernát Marcell