SL922
Active Member
I need to convert the time from format hhmmss to hh:mm:ssAM or hh:mm:ssPM
I used B9800188 (input as 784 and 0 for formatMode) which converts the time 784 to 00:07:59 not 07:08:04
but this function is correct if the time is 141310, it converts to 14:13:10
Is anybody aware of this problem?
Does anybody know how to convert the 784 to correct time or aware of any existing bsfn which can convert this?
Thanks advance for any input
E910 TR 9.1.2.2 SQL 2008 R2
I used B9800188 (input as 784 and 0 for formatMode) which converts the time 784 to 00:07:59 not 07:08:04
but this function is correct if the time is 141310, it converts to 14:13:10
Is anybody aware of this problem?
Does anybody know how to convert the 784 to correct time or aware of any existing bsfn which can convert this?
Thanks advance for any input
E910 TR 9.1.2.2 SQL 2008 R2