[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
On 27-01-2011 02:29:11 -0800, Ramkumarlak wrote:
Hi,
Let me know whether the following MYSQL functions are available in MonetDB.
- concat()
yes, or use ||
- date()
CAST(X AS DATE)
- from_unix_time()
unfortunately not
- interval()
I cannot find such function in the MySQL reference, but we do support the INTERVAL type
- Weekday()
I think not, don't know an equivalent either.
Fabian Groffen wrote:
- 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