Re: Timestamps in Oracle, Newbie question!

I think we can format the timestamp to format you mentioned that is

yyyymmdd-hh.mm.ss with the following

here's a select statement

select to_char(sysdate,'yyyymmdd-hh.mm.ss') from dual;

try this out... and let me know what happened.

bye

Paolo Rossi wrote in message <378cbbdf.4264952_at_news.tin.it>...
>Hi!
>We are trying to migrate an application from DB2 UDB 5.2 to Oracle 8
>and are encountering some problems with timestamp fields!
>
>The problem lies in the fact that in DB2 timestamp fields have a
>format like yyyymmdd-hh.mm.ss.xxxxxx which is something we have not
>been able to obtain in Oracle!
>
>Could anyone please tell me how timestamps are treated in Oracle and
>how can I format such fields in a as close as possible way to the DB2
>format, in order to maintain the application as transparent as
>possible to the DB platform in use?
>
>TIA
>
>Paolo Rossi
>
Received on Tue Jul 13 1999 - 01:05:27 CDT