Implement SQL Date and Time functions with documentations about gql HOT 12 CLOSED

also i noticed that SELECT CURRENT_DATE() returns a timestamp, while in sql it returns the date in yyyy-mm-dd format.
is this intended or a bug that should be fixed?

from gql.

also i noticed that SELECT CURRENT_DATE() returns a timestamp, while in sql it returns the date in yyyy-mm-dd format. is this intended or a bug that should be fixed?

You are right, its intended to represent the internal value of Date and DateTime as time stamp i64 so we can perform apply operators on them and at the end the literal representation should be formatted date,

I will update the literal representation now

Update: Done, after finishing NOW function git pull and it will print the date time in format

from gql.

I am on NOW

from gql.

I am on DAYNAME

from gql.

I am on MONTHNAME

from gql.

I am on DAYOFYEAR

from gql.

I am on HOUR

from gql.

I am on YEAR

from gql.

I am on MONTH

from gql.

I am on LAST_DAY

from gql.

I am on MINUTE

from gql.

I am on WEEKDAY

from gql.