[EMAIL PROTECTED] wrote: > > Hello, > > I'm porting an application from postgresql and am > having trouble with date and time conversions. > > I have lots of selects like this one: > > SELECT TO_CHAR(data,'DD/MM/YYYY'), TO_CHAR(hora,'HH:MM') FROM... > > I hoped this would at least work in Oracle mode, but it > doesn't for DATE and > TIME fields. > > Is there any way I could do this?
As Oracle only knows the datatype DATE which includes date and time-info, the internal datatype TIMESTAMP and the Oracle-datatype DATE are handled the same. Oracle does not know datatypes like the internal-mode DATE and TIME. For this reason the Oracle-function TO_CHAR is available only for Oracle-DATE == internal TIMESTAMP. In internal mode the function CHAR may help, if you can use the internal mode in that context. Elke SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
