[MonetDB-users] date functions in monetdb
Hi, Let me know whether the following MYSQL functions are available in MonetDB. 1) concat() 2) date() 3) from_unix_time() 4) interval() 5) Weekday() If not, are there any equivalent functions available ? Regards Ram -- View this message in context: http://old.nabble.com/date-functions-in-monetdb-tp30775963p30775963.html Sent from the monetdb-users mailing list archive at Nabble.com.
On 27-01-2011 02:29:11 -0800, Ramkumarlak wrote:
Hi,
Let me know whether the following MYSQL functions are available in MonetDB.
1) concat()
yes, or use ||
2) date()
CAST(X AS DATE)
3) from_unix_time()
unfortunately not
4) interval()
I cannot find such function in the MySQL reference, but we do support the INTERVAL type
5) Weekday()
I think not, don't know an equivalent either.
Fabian Groffen wrote:
5) Weekday()
I think not, don't know an equivalent either.
Yes you do! dayofweek, but in contrast to the MySQL equivalent, the first day is Sunday, not Monday. Regards, Daniel
------------------------------------------------------------------------------ Special Offer-- Download ArcSight Logger for FREE (a $49 USD value)! Finally, a world-class log management solution at an even better price-free! Download using promo code Free_Logger_4_Dev2Dev. Offer expires February 28th, so secure your free ArcSight Logger TODAY! http://p.sf.net/sfu/arcsight-sfd2d _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
participants (3)
-
Daniel Boesswetter -
Fabian Groffen -
Ramkumarlak