Using orientdb-community-1.7-rc2 version.
On Friday, June 20, 2014 11:39:10 AM UTC+5:30, David wrote: > > 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.
