Re: MySQL unix_timestamp() equivalent?

29 Feb 2016

      Hi Mark,

Thanks for the prompt reply. But it seems not working in my installation. I
am using Jan2014 release. Is this function available in that bundle?

I got this message when I tried executing the above example.

$ ./bin/mclient -d testdb
Welcome to mclient, the MonetDB/SQL interactive terminal (Jan2014)
Database: MonetDB v11.17.9 (Jan2014),
'mapi:monetdb://vijay-1833:50000/crmdb'
Type \q to quit, \? for a list of available commands
auto commit mode: on
sql>SELECT epoch(1456741924);
SELECT: no such unary operator 'epoch(int)'

Please help me with what I'm missing here. Thanks a ton in advance.

Thanks & Regards,

Vijayakrishna.P.
Mobile : (+91) 9500402305.

On Mon, Feb 29, 2016 at 4:02 PM, Mark Raasveldt 
wrote:
...
Hey Vijay,
The function sys.epoch converts an epoch value to a timestamp.
sql>SELECT epoch(1456741924);
+----------------------------+
| epoch_single_value         |
+============================+
| 2016-02-29 10:32:04.000000 |
+----------------------------+
1 tuple (1.184ms)
Hope that helps,
Mark
On Mon, Feb 29, 2016 at 11:27 AM, Vijay Krishna 
...
wrote:
...
Yes, I have come across this solution, Robin.
But my problem involves *converting epoch (a bigint value) into Date or
Timestamp*.
I went through the Temporal functions page and a few questions in the
user thread in the past, but am unable to find a solution till now.
Any help much appreciated.
Thanks & Regards,
Vijayakrishna.P.
Mobile : (+91) 9500402305.
On Mon, Feb 29, 2016 at 11:43 AM, Robin Cijvat <
robin.cijvat@monetdbsolutions.com> wrote:
...
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 listusers-list@monetdb.orghttps://www.monetdb.org/mailman/listinfo/users-list
_______________________________________________
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
_______________________________________________
users-list mailing list
users-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/users-list