Vitor Varalonga wrote: > I'm working on a InterBase Database that I recently migrated to SAPDB. > The Date format I've used on InterBase was "dd.mm.yyyy" and I've noticed > SAPDB is working with the format "yyyy-mm-dd" for the TIMSTAMP datatype. > Is there any SQL function similar to SQL Server CONVERT funtion that > allows me to convert the date to a specific format?
For TIMESTAMP the format "yyyy-mm-dd" is not supported. This format is supported for datatype DATE with date_time_format ISO or JIS. see the whole list of formats: http://www.sapdb.org/htmhelp/48/0d8018b4f211d2a97100a0c9449261/frameset.htm To use different date_time_formats one can specify the installation-parameter of the database named DATE_TIME_FORMAT. To change the format of one value, use the function CHAR, see http://www.sapdb.org/htmhelp/48/b4e434c0ca11d2a97100a0c9449261/frameset.htm Elke SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
