I'm trying to write a SQL statement that needs
some data type casting/conversion. I can't
seem to find the documentation to do this.
The following expression:
rec_entry_date > SUBTIME(TIME, '00:15:00')
Gives the error:
Integrity constraint violation;-8006 POS(61) Data types must be
compatible.
In Oracle you would do something like:
rec_entry_date > CAST(SUBTIME(TIME, '00:15:00') AS DATE)
But that does not work.
I don't want to switch on the "use Oracle syntax" option,
there must be a way to express this natively.
---------------------------------------------------------------------------
Alan Penny
Software Analyst
Clinical Reference Laboratory, Inc.
email: [EMAIL PROTECTED]
voice: +01 913-693-2536
fax: +01 913-492-1622
web: www.crlcorp.com
DISCLAIMER: The information in this message is confidential and may be
legally privileged. It is intended solely for the addressee. Access to this
message by anyone else is unauthorized. If you are not the intended
recipient, any disclosure, copying, or distribution of the message, or any
action or omission taken by you in reliance on it, is prohibited and may be
unlawful. Please immediately contact the sender if you have received this
message in error. Thank you.
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
