cancel
Showing results for 
Search instead for 
Did you mean: 

Problem with Datetime Fields

Former Member
0 Kudos

Hi everyone,

I need Document's Creation Date Field save the Time, because when I look the Datetime Field in the DB just the Date is saved. Is there a Parameter that controls this? or perhaps is something about my SQL Server?

Thanks for you help,

Josue Gamarro Quintana

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Josue

Although the structure of the date fields is DATETIME, SAP only saves the date. There is a time stamp field in the ADOC table you can refer to (CreateTime if I recall).

Kind regards

Peter Juby

Former Member
0 Kudos

Hi Peter,

Thaks for you answer, In the ADOC Table there is a DOCTIME field but is a smallint, how can I transform this to a standard time format like "14:25",

Thanks

Josue Gamarro Quintana

Former Member
0 Kudos

What you can do is to export to excel and use format to get the right time.

Thanks,

Gordon

Former Member
0 Kudos

Hi Gorden,

Thanks for the tip, I also notice that if the field value is 1030 this means 10:30 AM, and if the value is 1805 this means 6:05 pm. so I can just convert to time in this way.

Regards

Josue Gamarro Quintana

Answers (0)