Hello,

There might be a way of constructing a timestamp in MonetDB from an epoch, but I can not think of one. Regarding the reference that you gave to unix_timestamp (generating date or times from strings): we have something similar in MonetDB, some examples:

SELECT str_to_date('23-09-1987', '%d-%m-%Y') AS "date",
 str_to_time('11:40', '%H:%M') AS "time",
 str_to_timestamp('23-09-1987 11:40', '%d-%m-%Y %H:%M') AS "timestamp";

+------------+----------+----------------------------+
| date       | time     | timestamp                  |
+============+==========+============================+
| 1987-09-23 | 11:40:00 | 1987-09-23 11:40:00.000000 |
+------------+----------+----------------------------+

On 28-02-16 07:28, Vijay Krishna wrote:

Hi, 

I am looking for an Epoch (bigint) to date/timestamp converter in MonetDB - something similar to unix_timestamp() in MySQL. 

I referred this page - https://www.monetdb.org/Documentation/SQLreference/Temporal and tried out a few functions, but it seems to work only with the existing Timestamp columns. 

Am I missing something here? 

I am using MonetDB Jan2014 release on a Mac OS-X.

Any help much appreciated. 

Thanks & Regards, Vijayakrishna.P. Mobile : (+91) 9500402305.

_______________________________________________
users-list mailing list
users-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/users-list

_______________________________________________
users-list mailing list
users-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/users-list