How to get current date and timestamp in OrientDB ?

[Gaurav Dhiman]

How to get current date and timestamp in OrientDB ?

Kindly share examples of both - in SQL command as well as using object methods (if possible).

Regards,

Gaurav

[Luca Garulli]

Hi,

use the date() function, like:

select date()

Lvc@

--

---
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 orient-databa...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Gaurav Dhiman]

This gives timestamp, what about just date ?

Also kindly inform how to set the timezone. I do not want the timezone of server to be picked.

Regards,

Gaurav

--

---
You received this message because you are subscribed to a topic in the Google Groups "OrientDB" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/orient-database/XVlbc33qd8M/unsubscribe.
To unsubscribe from this group and all its topics, send an email to orient-databa...@googlegroups.com.

[Luca Garulli]

You can pass it. Take a look at the documentation: https://github.com/orientechnologies/orientdb/wiki/SQL-Where

Lvc@