Re: %timestamp ??

Hi,

C/EXEC SQL   Set :MyTimeStamp = Current_TimeStamp
C/End-Exec

Mit freunlichen Grüßen / Best regards

Birgitta Hauser

"If you think education is expensive, try ignorance." (Derek Bok)

To: <rpg400-l@xxxxxxxxxxxx>
Sent: Tuesday, November 21, 2006 04:09
Subject: Re: %timestamp ??

Jim Wiant wrote in MIDRANGE-L Tue, 21 Nov 2006:

I usually use MyTimeStamp = %DATE + %TIME and that gives me the current
time (doesn't get the milliseconds though)

Hi Jim, much safer to use MytimeStamp = %TIMESTAMP.

If you also need the matching date and time, you could then do
  MyDate = %DATE(MyTimeStamp);
  MyTime = %TIME(MyTimeStamp);

Doing %DATE and %TIME separately, you might do the %DATE one side of
midnight and the %TIME the other side of midnight, giving you 24 hours
too early, say
  2006-10-20-00.00.01
rather than either
  2006-10-20-23.59.59
  2006-10-21-00.00.01

--
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.