I got some input from someone else. It looks like to
natively cast types in SAPDB (i.e., MAXDB) you
would use this syntax:
DATE(<column_expression>)
which worked, but the actual solution to my problem
turned out to be:
rec_entry_date > SUBTIME(TIMESTAMP, '00:15:00')
The column rec_entry_date is a TIMESTAMP type. The SUBTIME
worked on "TIMESTAMP" which used by itself gives the current
date/time in a TIMESTAMP format.
I am trying to find records that have been entered in the last
fifteen minutes from "now".
The above worked.
Thanks to all.....
> -----Original Message-----
> From: Zabach, Elke [SMTP:[EMAIL PROTECTED]
> Sent: Wednesday, April 14, 2004 1:12 AM
> To: Alan Penny; [EMAIL PROTECTED]
> Subject: RE: Data Type Casting
>
> Alan Penny wrote:
> >
> > 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.
>
> Sorry, but what do you want to do?
> You want to ask if a date
> (rec_entry_date is of Oracle-datatype date == internal datatype timestamp
> or the internal datatype date?)
> is greater than a time-value (with no date-part in) ?
>
> If rec_entry_date is of internal datatype timestamp, it includes a
> time-part,
> which can be extracted using the function time -->
> time (rec_entry_date) > SUBTIME (Time, '00:15:00),
> or the other way round (if the date-part has to be taken into account)
> rec_entry_date > timestamp (date, subtime(time, '00:15:00)).
>
> In case rec_entry_date is of internal datatype date I am happy that MaxDB
> is not able to compare date(without time-part) and time-values (without
> date-part),
> but produces the correct error -8006.
>
> Elke
> SAP Labs Berlin
>
> >
> > --------------------------------------------------------------
> > -------------
> > 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]
> >
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]
