Hi,
A query on sql - date function. I needed to convert the epoch seconds
time to date only format[ yyyy-mm-dd]. I was trying to use the date()
function mentioned here[1]. But this doesn't seem to be working. It returns
date-time completely even when the date only format is specified as
date(epochDate, 'yyyy-mm-dd') .
Ex: date(epochDate, 'yyyy-mm-dd') as newDate . Input: epochDate = 41943228,
returned = 1970-01-17 10:53:48.
Expected output was : 1970-01-17 [ yyyy-mm-dd / yyyy-dd-mm format] without
time stamp
[1] https://github.com/orientechnologies/orientdb/wiki/SQL-Functions#date
If this is the bug, can you please help me with the sample example on
how to create the user- defined sql function with parameter. I can use this
as the solution.
In the link [2], there are samples for creating sql user defined function
but it is for cases without parameter. I tried using sql syntax [ creating
user defined function [3] with parameter] but it seems like I was not
correct. A sample with parameter would be of great help.
[2] https://github.com/orientechnologies/orientdb/wiki/SQL-Create-Function.
[3]http://www.sqlteam.com/article/intro-to-user-defined-functions-updated
--
---
You received this message because you are subscribed to the Google Groups
"OrientDB" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
