STRING(TIME,"HH:MM:SS")
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Vic Drecchio
Sent: Friday, February 10, 2012 3:54 PM
To: Vantage Yahoo
Subject: [Vantage] 4GL code to convert SYSTIME format
I’m writing a BPM to log user, date and time to UDF’s when a record is Inserted or Updated in a UD table.
I know I can set TIME() = Number01 and that’ll give me the lovely seconds-since-midnight integer value. Which, to most, is meaningless without a calculator and 10 minutes of concentration.
I’ve converted the time in Crystal before, not a biggie. Also done it in SQL.. again, not bad. But in the BPM world I’m unable to convert 53145 to “14:46:01â€
Anyone have a snippet that they’d be willing to share? TIA.
Vic
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Vic Drecchio
Sent: Friday, February 10, 2012 3:54 PM
To: Vantage Yahoo
Subject: [Vantage] 4GL code to convert SYSTIME format
I’m writing a BPM to log user, date and time to UDF’s when a record is Inserted or Updated in a UD table.
I know I can set TIME() = Number01 and that’ll give me the lovely seconds-since-midnight integer value. Which, to most, is meaningless without a calculator and 10 minutes of concentration.
I’ve converted the time in Crystal before, not a biggie. Also done it in SQL.. again, not bad. But in the BPM world I’m unable to convert 53145 to “14:46:01â€
Anyone have a snippet that they’d be willing to share? TIA.
Vic
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]