Timestamp format

[Former Member]

Dear programmers,

I've made a little webdynpro application to show a table with some data.

I am using the default DB from SAP and used the field type "TIMESTAMP".

The date is formatted like this: YYYY-MM-DD T HH:MM:SS

Is it possible to change this format into "MM-YYYY"?

In advance,

Adri

P.s. We would deploy the application also at a server with an Oracle database installed. Do you think that would work.

[Former Member · Accepted solution]

Adri,

You need to create custom type in Local Dictionary of WD project that is based on timestamp. For this type you must define own format/pattern in settings like MM-yyyy.

Then use this type for context attributes instead of built-in timesdtamp type.

<i>P.s. We would deploy the application also at a server with an Oracle database installed. Do you think that would work. </i>

Nothing in NW prevents this :). The rest depends on how you write your SQL, i.e. whether or not your SQL queries are portable.

Valery Silaev

SaM Solutions

http://www.sam-solutions.net

[Former Member]

Cool! It's working.

Simple type = timestamp (default = string)

Thanks a lot.