Regarding the Date Functions in N1QL


#1

Hi,

I have a query regarding the date functions in N1QL. Is it possible to get the current sysdate in a specific formate?
Like if i want sysdate to be returned in YYY-MM-DD format, how can i do that? Can anybody please reply? Also in the developer preview 4 they have mentioned plenty of date functions like CLOCK_STR([ fmt ]). But the format and example is not mentioned.


#2

SELECT CLOCK_STR(“2006-01-02”);

"results": [
    {
        "$1": "2015-03-24"
    }
],