Skip to Content
author's profile photo Ivan Leonardo
0
Ivan Leonardo

Record, Time data type

Posted on Dec 09, 2014 at 06:41 AM 14 Views

Hi,

I need to record a creation time on some table, and I have to add using UDF but it seems SAP only allow save time as numeric, for example 07:25:12AM I have to insert it to numeric field as 72512, I try using date/time field to save current_time but error.

Any tips or guide on working with time ?

And I need to save the time with 24hours format and 6digits such as 070520 (HHMMSS) not as 7520

Thanks

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    author's profile photo Johan Hakkesteegt
    Johan Hakkesteegt
    Posted on Dec 09, 2014 at 07:37 AM
    1

    Hi Ivan,

    In general B1 separates dates and times. A date field will only contain the date component. The time is usually stored in a smallint field.

    When set the UDF up as type DATE/TIME and set the structure to HOUR, the field should be displayed according to your Windows locale, even though the value is an integer in the database.

    Regards,

    Johan

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.