Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email firstname.lastname@example.org
Re: ¿ How to concatenate string and date types in a SQL Sentence ?
From: Florian Schmitz (fschmitzacardo.com)
Date: Mon Feb 07 2005 - 13:03:24 CST
Try select chr(month(curdate())) & ' ABCD ' from table
>I am trying to concatenate in a SQL Sentence a result of a function date
>with a string:
>SELECT MONTH ( CURDATE ( ) ) & ' SOMETHING... ' FROM DBA.DUAL
>But I got the message:
>Auto Commit: On, SQL Mode: Internal, Isolation Level: Committed
> Integrity constraint violation;-8006 POS(16) Data types must be
>SELECT MONTH ( CURDATE ( ) ) & ' MES' FROM DBA.DUAL
>It seems to be a data type incompatibility problem. I have been looking
>for convert or cast functions but I did´nt find anything.
>How can I concatenate the strings in this SQL Sentence?
>Thanks for your help!
>Luis Jorge Castro
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb