Re: Using to_char() in a WEBDB query

What are you talking about?

DateTime is not a sql function, SYSDATE is.

Or if you want so:

create or replace function DateTime
return date
is
begin
 return sysdate;
end;
/

Arnaldo Martins wrote in message <89dt7k$egc$1_at_duke.telepac.pt>...
>Try aliasing the column:
>
>Select ...., TO_CHAR(DATETIME, 'DD-MON-YY HH24:MI:SS') date_value
>from ....
>
>hope it works.
>
>Arnaldo
>Portugal
>
>Jacquie Armstrong <jacquieNOSPAM_at_softtracks.com> escreveu na mensagem
>news:38b32f11_at_rsl2.rslnet.net...
>>
>> I am using WebDB to create a report (based on an SQL Query), and one of
>the
>> fields is a date field. I want to display the time in a specific format
>using
>> to_char, but when I try to create the select statement in WebDb, the
>parser
>> complains and it won't let me. When I take this line out, the query
works
>> fine.
>>
>> to_char(datetime, 'DD-MON-YY HH24:MI:SS'),
>>
>> The errors I get are:
>> WWV-13010 Unable to describe SQL statement. Please correct it
>> ORA-06502 ORA-06502: PL/SQL: numeric or value error
>> WWV-13005 Invalid SQL statement: SELECT TransactionID,
>> TO_CHAR(DATETIME, 'DD-MON-YY HH24:MI:SS'),
>> TOTAL,
>> FROM MYSCHEMA.Detail;
>> ORA-06502 ORA-06502: PL/SQL: numeric or value error
>>
>> Any ideas on how I can format the time the way I want to?
>>
>> Thanks,
>> Jacquie.
>>
>
>
Received on Mon Feb 28 2000 - 09:46:39 CST