Thank's for your answer, Peter.
No I did not try any string function.
Using oracle you can use to_date easily. I need to do that to
integrate a generic component that uploads csv file just by using
string fields. Is there really no way to convert a string into a date
in where clauses ?
Regards
-Alexander-
Original Message:
-----------------
From: [EMAIL PROTECTED] (Peter Willadt)
Date: Fri, 10 Jan 2003 11:54:35 +0100
To: [EMAIL PROTECTED], [EMAIL PROTECTED],
[EMAIL PROTECTED]
Subject: Re: DATE PROBLEM in WHERE clause
Hello,
On Donnerstag, 9. Januar 2003 16:05, [EMAIL PROTECTED] wrote:
> Hi everyone,
>
> The column is a STRING column called TEST_DATE containing values
> in the format DD.MM.YYYY.
> All I want to do saying something like
> WHERE TO_DATE('DD.MM.YYYY') > TO_DATE(05.04.2002').
> I tried moving to the DATE() function or using another
> date format, but I am always getting an error
> like Datetime field overflow or invalid function.
>
if it is a string column, you can probably not use date functions, but
string
functions. If you have rto use dat functions, you should make it a date
column, shouldn't you?
Peter Willadt
--------------------------------------------------------------------
mail2web - Check your email from the web at
http://mail2web.com/ .
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
