|
Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com |
Re: ¿ How to concatenate string and date types in a SQL Sentence ?
From: Florian Schmitz (fschmitz
acardo.com)
Date: Mon Feb 07 2005 - 13:03:24 CST
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Try select chr(month(curdate())) & ' ABCD ' from table
tmxluisjorge.castrokof.com.mx wrote:
>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
>compatible
>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
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]