Data element TIMESTAMP output length..!

[naveen_inuganti2]

Hi,

As we know there is a Dataelement TIMESTAMP to save time stamp, which contains DEC data type length 15 and Output Length 19.

So if I wants to save Date 07/03/2009 and Time 04:36:45 in this field it can be 20,090,703,043,645.

Here we can see comma also in output.

My requirement is to avoid these commas, so it would be 20090703043645.

I can change the Data element.

But my question is, Will this create any other issues later? Why this data element giving output like that..?

Finally is that correct idea to change this... Data element..?

Please let me know.

Thanks,

Naveen Inuganti.

[Former Member]

Hi,

If you want the timestamp i don't think it would be possible to change the dataelement if you are using the statement

CONVERT CONVERT DATE dat TIME tim DAYLIGHT SAVING TIME 'X'
        INTO TIME STAMP time_stamp TIME ZONE tz.

so its better to get the timestamp in the same format and move it to the character of length 15 and display it.

Regards

Sarves

[Former Member]

Hi,

Q1. This is no matter how u store the data. If u want to use the data then it will be a problem. It will not be fit into a time stamp variable.

Q2. As it is dec data type the commas are thousand seperator.

Q3. Let it be as it is.... it is better to handle the value applying logic.

Amitava

[Former Member]

as us said ,

My requirement is to avoid these commas, so it would be 20090703043645.

this means u vll be using the above said '20090703043645' instead of '20,090,703,043,645'.

so if u want to use it else then go head and declare a new data elt

but if agn if u want move it to timestamp FM then

jus convert it before moving it to the FM (timestamp type DEC)

this is as far as i cud understand ,

pls explain ur scenario clearly

regads

venkat