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.
Hi,
I'm trying to bulk load data into monetdb through COPY INTO statement on the fly.
I've created an aggregator script that will create a session and send chunk of data using MAPI interface.
Like this:
"sCOPY INTO foo FROM STDIN USING DELIMITERS ',','\\n';"
//+ "\n"
+ "100,10,0,'10'\n"
+ "\n"
I've been following this example: http://dev.monetdb.org/hg/MonetDB/file/tip/java/example/SQLcopyinto.java (haven't tested) I planned to add as part of the monetdb nodejs module: https://github.com/MonetDB/monetdb-nodejs/issues/1
but seems to be out of the scope of that repository.
Sadly I'm not getting any error just doesn't work.
What's the correct way ?
Thanks.
