4GL code to convert SYSTIME format

Yahoo Archive
1
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]
2
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]
3
Ahh..... got it from a good friend of mine.... MUCH EASIER than I would have thought... go figure: STRING(TIME,"HH:MM:SS")

So my simple code looks like:

for each ttUD01 where ttUD01.RowMod = 'A' or ttUD01.RowMod = 'U' no-lock.
Assign ttUD01.Date01 = TODAY.
Assign ttUD01.ShortChar01 = DCD-USERID.
Assign ttUD01.Number01 = TIME.
Assign ttUD01.ShortChar02 = STRING(TIME,"HH:MM:SS").
End.

Thanks “Friend”.


Vic


From: Vic Drecchio
Sent: Friday, February 10, 2012 2: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]




No virus found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.1913 / Virus Database: 2112/4801 - Release Date: 02/10/12


[Non-text portions of this message have been removed]