List:MaxDB« Previous MessageNext Message »
From:Elke Zabach Date:April 16 2003 4:08pm
Subject:RE: to_char with sapdb
View as plain text  
Yusuf Kör wrote:

> I Have following sql in Oracle
> 
> select distinct TO_CHAR(KWUSR_TIME_CREATED, 'YYYY-MM-DD') 
> SDATE, KWUSR_ID
> 
> from KW_USER
> 
> order by TO_CHAR(KWUSR_TIME_CREATED, 'YYYY-MM-DD')
> 
> how can I migrate it to sapdb?

Use the statement as in Oracle and use sqlmode oracle

Elke
SAP Labs Berlin
Thread
• to_char with sapdbykoer16 Apr
• RE: to_char with sapdbElke Zabach16 Apr